[B! sql] stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

stibbar id:stibbar

sqlã«é–¢ã™ã‚‹stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€INNER JOIN, LEFT JOIN , RIGHT JOINã€‘ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆã®æŒ™å‹•ã‚’ã¾ã¨ã‚ã¦ã¿ãŸã€SQLã€‘ - Qiita
ã¯ã˜ã‚ã« ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆã®å‹•ä½œã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸï¼ ãƒã‚°ã‚’è¦‹ãŸæ™‚ã«ã€ä½•ã—ã¦ã‚‹ã‹åˆ†ã‹ã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã‚’ä»Šå›žã®ç›®çš„ã¨ã—ã¾ã™ã€‚ æœ¬è¨˜äº‹ã¯ã€å…¨ã¦å‹•ä½œæ¸ˆã¿ã§ã™ã€‚ DBMS: Mysql ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆã®æŒ™å‹•ã«ã¤ã„ã¦ ã¾ãšã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆãŒã©ã®ã‚ˆã†ã«è¡Œã‚ã‚Œã¦ã„ã‚‹ã®ã‹è¦‹ã¦è¡Œãã¾ã—ã‚‡ã†ã€‚ çµåˆã«ã¯JOINå¥ãŒä½¿ã‚ã‚Œã¾ã™ã€‚ ä½¿ã„æ–¹
stibbar 2021/06/22
qiita

sql
ãƒªãƒ³ã‚¯
MySQL ã§ãƒ‡ãƒ¼ã‚¿ã®ç¯„å›²ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã®å€‹æ•°ã‚’é›†è¨ˆã™ã‚‹ - mdknâ€™s blog
MySQL ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç¯„å›²ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã®å€‹æ•°ã‚’é›†è¨ˆã—ãŸã„ã¨æ€ã„ã¾ã—ãŸã€‚ä»¥ä¸‹ã®è¨˜äº‹ã«æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ã‚’ MySQL ã§ã‚„ã‚ŠãŸã‹ã£ãŸã®ã§èª¿ã¹ã¾ã—ãŸã€‚ [Excel] ãƒ‡ãƒ¼ã‚¿ã®ç¯„å›²ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã®å€‹æ•°ã‚’é›†è¨ˆã™ã‚‹ - ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã—ãŸ å€¤ã®ç¯„å›²ã”ã¨ã®äººæ•°é›†è¨ˆ (å¹´ä»£ã€ä¾¡æ ¼å¸¯ã€å¾—ç‚¹å¸¯ã§ã®é›†è¨ˆæ–¹æ³•) ç’°å¢ƒ $ mysql --version mysql Ver 14.14 Distrib 5.6.34, for osx10.11 (x86_64) using Edit Line wrapper æº–å‚™ ä»Šå›žã¯ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦0 ~ 100 ç‚¹ã¾ã§ã®æˆç¸¾ã®é›†è¨ˆã‚’æƒ³å®šã—ã¾ã™ã€‚ mysql> create database sampletables; Query OK, 1 row affected (0.02 sec) mysql> use sampletables Database changed my
stibbar 2021/05/26
sql

mysql
ãƒªãƒ³ã‚¯
Presto: Free, Open-Source SQL Query Engine for any Data
Fast and Reliable SQL Engine for DataÂ Analytics and the OpenÂ Lakehouse Learn more about our active development of Presto 2.0, the C++ native engine and next-generation version ofÂ Presto.Â â†’
stibbar 2021/04/09
presto

sql
ãƒªãƒ³ã‚¯
ã€SQLã€‘çµæžœã®çµ±åˆã¯UNIONã§!ã ã‚Œã§ã‚‚ã‚ã‹ã‚‹UNIONè§£èª¬! | ä¾ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã¿ãªã•ã‚“ã“ã‚“ã«ã¡ã¯!ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®satoã§ã™ã€‚ ä»Šå›žã¯UNIONã«ã¤ã„ã¦è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚UNIONã¯äºŒã¤ä»¥ä¸Šã®SELECTã®çµæžœã‚’ã€çµ±åˆã—ã¦è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ä»•çµ„ã¿ã§ã™ã€‚ã“ã‚Œã‚’ä½¿ãˆã‚Œã°ã€ã¾ãŸä¸€ã¤é«˜åº¦ãªçµæžœè¡¨ç¤ºã‚’è¡Œãˆã¾ã™ã®ã§ãœã²è¦šãˆã¦ã—ã¾ã„ã¾ã—ã‚‡ã†ã€‚ [åŸºæœ¬]UNIONã¨ã¯ [åŸºæœ¬]UNIONã®ç¨®é¡ž [åŸºæœ¬]UNIONã®ä½¿ã„æ–¹ [å¿œç”¨]UNIONå¾Œã«ã€ŒORDER BYã€ã‚’ä½¿ç”¨ã™ã‚‹ [å¿œç”¨]UNIONå¾Œã«ã€ŒGROUP BYã€ã‚’ä½¿ç”¨ã™ã‚‹ ä»Šå›žã¯å‰åŠã§ã€ŒUNIONã®ç¨®é¡žã€ã€ŒUNIONã®ä½¿ã„æ–¹ã€ã¨ã„ã£ãŸåŸºç¤Žçš„ãªå†…å®¹ã‚’è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ãã—ã¦å¾ŒåŠã§ã€ã‚ˆãç–‘å•ã¨ã—ã¦ä¸ŠãŒã‚‹UNIONå¾Œã«ã€ŒORDER BYã€ãªã©ã‚’ã‹ã‘ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è¦‹ã¦ãã¾ã—ã‚‡ã†ã€‚ UNIONã¨ã¯ UNNIONã¨ã¯ã€å†’é ã§ã‚‚è¨€ã„ã¾ã—ãŸãŒäºŒã¤ä»¥ä¸Šã®SELECTã®çµæžœã‚’ã€çµ±åˆã—ã¦è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ä»•çµ„ã¿ã®ã“ã¨ã‚’è¨€ã„ã¾ã™ã€‚ ä¾‹ãˆã°ã™ã”ãã‚·
stibbar 2021/03/09
sql
ãƒªãƒ³ã‚¯
[Redshift][PostgreSQL] WITHå¥ã‚’ä½¿ã£ã¦SQLã‚’ã‚·ãƒ³ãƒ—ãƒ«ã«ã€‚ | DevelopersIO
ç’°å¢ƒ MAC OSX 10.10.5 Yosem ite ä½¿ã„æ–¹ï¼ˆä¾‹ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æº–å‚™ CREATE TABLE it ems ( id SMALLINT , name VARCHAR(16) , it em_id SMALLINT , it em_name VARCHAR(16) , PRIMARY KEY(id, it em_id) ); INSERT INTO it ems VALUES (1, 'æ–‡æˆ¿å…·', 1, 'ã‚·ãƒ£ãƒ¼ãƒšãƒ³') , (1, 'æ–‡æˆ¿å…·', 2, 'æ¶ˆã—ã‚´ãƒ ') , (1, 'æ–‡æˆ¿å…·', 3, 'å®šè¦') , (2, 'ã‹ã°ã‚“', 1, 'ãƒªãƒ¥ãƒƒã‚¯ã‚µãƒƒã‚¯') , (2, 'ã‹ã°ã‚“', 2, 'ã‚·ãƒ§ãƒ«ãƒ€ãƒ¼ãƒãƒƒã‚°'); CREATE TABLE genre ( id SMALLINT , name VARCHAR(16) ,PRIMARY KEY(id) ); # SELECT *
stibbar 2021/01/15
classmethod

sql
ãƒªãƒ³ã‚¯
How to Alter Redshift Table column Data type? Explanation - DWgeek.com
stibbar 2020/10/14
redshift

aws

sql
ãƒªãƒ³ã‚¯
LEFT JOIN AS new column?
stibbar 2020/01/31
sql

stackoverflow
ãƒªãƒ³ã‚¯
åˆ¥ã€…ã«å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’çµåˆã—ã¦å–å¾—ã™ã‚‹(UNIONå¥)
UNION ã¯è¤‡æ•°ã® SELECT æ–‡ã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’ãã‚Œãžã‚Œå–å¾—ã—ã€ãã®çµæžœã‚’çµåˆã—ãŸä¸Šã§1ã¤ã®ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã™ã‚‹å ´åˆã«ä½¿ã„ã¾ã™ã€‚æ›¸å¼ã¯æ¬¡ã®é€šã‚Šã§ã™ã€‚ SELECT col_name1, ... FROM table_name1 UNION [ALL | DISTINCT] SELECT col_name2, ... FROM table_name2 [UNION [ALL | DISTINCT] ...] æœ€åˆã® SELECT æ–‡ã§å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã«ã€æ¬¡ã® UNION ã®ã‚ã¨ã® SELECT æ–‡ã§å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’çµåˆã—ã¦å–å¾—ã—ã¾ã™ã€‚ 3 ã¤ä»¥ä¸Šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã—ãŸã„å ´åˆã¯ UNION ä»¥ä¸‹ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ•°ã ã‘è¨˜è¿°ã—ã¦ãã ã•ã„ã€‚ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ã‚«ãƒ©ãƒ åã¯æœ€åˆã® SELECT æ–‡ã®ã‚ã¨ã«è¨˜è¼‰ã•ã‚ŒãŸã‚«ãƒ©ãƒ åã¨ãªã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œã® SELECT æ–‡ã§å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ã‚«ãƒ©ãƒ ã®æ•°ã¯åŒã˜ã§ã‚ã‚‹å¿…è¦ãŒ
stibbar 2020/01/31
sql
ãƒªãƒ³ã‚¯
MySQL æ—¥æ™‚ã”ã¨ã®é›†è¨ˆã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? æœˆåˆ¥ã€æ—¥åˆ¥ã€æ™‚é–“åˆ¥ã«ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’é›†è¨ˆ ä¸€æœˆæ¯Ž mysql> SELECT DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y-%m') AS time, COUNT(*) AS count FROM ãƒ†ãƒ¼ãƒ–ãƒ«å GROUP BY DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y%m'); ä¸€æ—¥æ¯Ž mysql> SELECT DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y-%m-%d') AS time, COUNT(*) AS count FROM ãƒ†ãƒ¼ãƒ–ãƒ«å GROUP BY DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y%m%d'); ä¸€æ™‚é–“æ¯Ž mysq
stibbar 2019/09/10
qiita

SQL
ãƒªãƒ³ã‚¯
SQL ã§ç´¯ç©ï¼ˆæ•°é‡ã€é‡‘é¡ãªã©ï¼‰ã‚’å–å¾—ã™ã‚‹æ–¹æ³• - SQL Server - Project Group
CREATE TABLE WORK_DATA( æœˆåº¦ smallint ,é‡‘é¡ decimal(18,0) ) INSERT INTO WORK_DATA VALUES(4,1000) INSERT INTO WORK_DATA VALUES(5,1200) INSERT INTO WORK_DATA VALUES(6,1500)
stibbar 2019/08/19
https://support.treasuredata.com/hc/ja/articles/216392117-Window-%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%84%E3%81%93%E3%81%AA%E3%81%99-%E9%9B%86%E7%B4%84%E9%96%A2%E6%95%B0%E7%B3%BB-

sql
ãƒªãƒ³ã‚¯
SQLã§ãƒ•ã‚£ãƒœãƒŠãƒƒãƒæ•°åˆ—ã‚’æ›¸ã„ãŸ - Qiita
postgres=# select version(); version ------------------------------------------------------------- PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit (1 è¡Œ) å†å¸°å‘¼ã³å‡ºã—ã®èª²é¡Œã¨ã—ã¦ã‚ˆãåˆ©ç”¨ã•ã‚Œã‚‹ã®ãŒãƒ•ã‚£ãƒœãƒŠãƒƒãƒæ•°åˆ—ã€‚DBMSã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒã€SQLã§ã‚‚å†å¸°å‘¼ã³å‡ºã—(å†å¸°ã‚¯ã‚¨ãƒª)ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã®ã§ã€SQLã§ãƒ•ã‚£ãƒœãƒŠãƒƒãƒæ•°åˆ—ã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ with recursive fib (x, a, b) as ( select 0, cast(0 as decimal), cast(1 as decimal) union all select x + 1, b, a + b from fib where x < 100 )
stibbar 2019/08/19
qiita

sql
ãƒªãƒ³ã‚¯
ã“ã‚Œã§ã‚ã‹ã£ãŸ!? LEFT / RIGHT JOIN. - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
stibbar 2019/05/08
qiita

sql
ãƒªãƒ³ã‚¯
Google BigQueryã®æ–°æ©Ÿèƒ½ Standard SQLã¾ã¨ã‚ - ZOZO TECH BLOG
ã“ã‚“ã«ã¡ã¯ã€VASILYãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å¡©å´Žã§ã™ã€‚ VASILYã§ã¯æ§˜ã€…ãªãƒã‚°ãƒ‡ãƒ¼ã‚¿ã®åˆ†æžã«BigQueryã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ä½•ã‚‚è€ƒãˆãªãã¦ã‚‚è‰¯ã„ã®ãŒç‰¹ã«ä¾¿åˆ©ã§ã™ã€‚ ã•ã¦ã€ãã‚“ãªBigQueryã§ã™ãŒã€æ•°ã‹æœˆå‰ã«Standard SQLã¨ã„ã†æ–°ã—ã„ä»•æ§˜ã®SQLãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¾ã—ãŸã€‚ BigQuery 1.11, now with Standard SQL, IAM, and partitioned tables! VASILYã§ã‚‚å¾ã€…ã«Standard SQLã«ç§»è¡Œã‚’ã—ã¦ã„ã‚‹ã®ã§ã€ä½¿ã„å‹æ‰‹ã‚„å¾“æ¥ã®SQLã‹ã‚‰ã®ç§»è¡Œæ–¹æ³•ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ Standard SQLã¨ã¯ SQL:2011ã«æº–æ‹ ã—ã¤ã¤ã€é…åˆ—ã‚„æ§‹é€ ä½“ç‰ã®æ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«æ‹¡å¼µã•ã‚ŒãŸSQLã§ã™ã€‚ Standard SQLã®ç™»å ´ã«ã‚ˆã£ã¦ã€ä»¥å‰ã‹ã‚‰ã‚ã£ãŸSQLã¯Legacy SQLã¨å‘¼ã°ã‚Œã‚‹ã‚ˆ
stibbar 2019/04/03
sql
ãƒªãƒ³ã‚¯
MySQLã§GROUP BYã¨ORDER BYã‚’åŒæ™‚ã«ä½¿ç”¨ã™ã‚‹å ´åˆã«æ°—ã‚’ã¤ã‘ãŸã„ã“ã¨ | æ—¥è¨˜ã®é–“ | ã‚ã‹ã¤ãã®ãŠå®¿
ä»Šã•ã‚‰ãªè©±ã§ã¯ã‚ã‚‹ã‚“ã§ã™ãŒã€å‰ã«ã‚‚ä¸€åº¦åŒã˜éŽã¡ã‚’çŠ¯ã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã€ã“ã“ã§ã¡ã‚ƒã‚“ã¨è‡ªåˆ†ã‚’æ‡²ã‚‰ã—ã‚ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ å‰ææ¡ä»¶ ä¾‹ãˆã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã“ã‚“ãªãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ã‚‹ã¨ã™ã‚‹ã€‚ +----+-----------+--------+------+---------------------+ | id | author_id | title | text | created | +----+-----------+--------+----------------------------+ | 1 | 1 | title1 | text | 2012-10-01 12:00:00 | | 2 | 2 | title2 | text | 2012-10-02 12:00:00 | | 3 | 1 | title3 | text | 2012-10-03 12:00:00 | | 4
stibbar 2019/04/01
sql
ãƒªãƒ³ã‚¯
Amazon.co.jp: ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQLãƒ¬ã‚·ãƒ”: åŠ åµœé•·é–€ (è‘—), ç”°å®®ç›´äºº (è‘—), ä¸¸å±±å¼˜è©© (ç·¨é›†): Digital Ebook Purchas
stibbar 2018/12/07
amazon

SQL

book
ãƒªãƒ³ã‚¯
Facebookã€åˆ†æ•£SQLã‚¨ãƒ³ã‚¸ãƒ³ã€ŒPrestoã€å…¬é–‹ã€‚å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’MapReduce/Hiveã®10å€åŠ¹çŽ‡ã‚ˆãå‡¦ç†ã™ã‚‹ã¨
Facebookã¯ã€æ•°ãƒšã‚¿ãƒã‚¤ãƒˆç´šã®å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã‚‚ã€å¯¾è©±çš„ã«ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªå•ã„åˆã‚ã›ã‚’å¯èƒ½ã«ã™ã‚‹åˆ†æ•£SQLã‚¨ãƒ³ã‚¸ãƒ³ã€ŒPrestoã€ã‚’ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã—ã¾ã—ãŸã€‚ Prestoã¯Facebookç¤¾å†…ã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®åˆ†æžã®ãŸã‚ã«é–‹ç™ºã•ã‚Œã€ã™ã§ã«åŒç¤¾ç¤¾å†…ä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚‚ã®ã€‚ Facebookã¯Prestoã‚’é–‹ç™ºã—ãŸèƒŒæ™¯ã¨ã—ã¦ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’Hadoop/HDFSãƒ™ãƒ¼ã‚¹ã§ä¿å˜ã—ãŸã‚‚ã®ã®ã€ãƒãƒƒãƒæŒ‡å‘ã®MapReduceã§ã¯ãªãã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ€§ã«å„ªã‚ŒãŸå‡¦ç†ãŒå¿…è¦ã«ãªã£ãŸãŸã‚ã ã¨ã€æ¬¡ã®ã‚ˆã†ã«èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ Facebookâ€™s warehouse data is stored in a few large Hadoop/HDFS-based clusters. Hadoop MapReduce [2] and Hive are designed for large-scale, reliabl
stibbar 2013/11/09
http://sourceforge.jp/magazine/13/11/08/064000

publickey

facebook

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
æœ¬æ›¸ã¯DBè¨è¨ˆã‚„SQLè¨˜è¿°ã®éš›ã«é¿ã‘ã‚‹ã¹ãäº‹æŸ„ã‚’1ç« ã§1ã¤ã€25å€‹ç´¹ä»‹ã™ã‚‹æ›¸ç±ã§ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸å¿ƒã«æ®ãˆãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«ã¯ã€æ§˜ã€…ãªå ´é¢ã§é™¥ã‚Šã‚„ã™ã„å¤±æ•—ï¼ˆã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ›¸ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆã€ã‚¯ã‚¨ãƒªã®è¨˜è¿°ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã¨ã„ã†4ã¤ã®ã‚«ãƒ†ã‚´ãƒªã«åˆ†ã‘ã€ãã‚Œãžã‚Œã®åˆ†é‡Žã«ãŠã‘ã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç´¹ä»‹ã—ã€å¤±æ•—ã‚’é¿ã‘ã‚‹ãŸã‚ã®ã‚ˆã‚Šè‰¯ã„æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚è¤‡æ•°ã®å€¤ã‚’æŒã¤å±žæ€§ã‚„å†å¸°çš„ãªãƒ„ãƒªãƒ¼æ§‹é€ ã®æ ¼ç´ã‹ã‚‰ã€å°æ•°å€¤ã®ä¸¸ã‚ã‚„NULLã®æ‰±ã„ã«èµ·å› ã™ã‚‹å•é¡Œã€å…¨æ–‡æ¤œç´¢ã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€MVCã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã©ã€å®Ÿè·µçš„ã‹ã¤å¹…åºƒã„ãƒˆãƒ”ãƒƒã‚¯ã‚’ç¶²ç¾…ã—ã¾ã™ã€‚æ—¥æœ¬èªžç‰ˆã§ã¯ã€MySQLã®ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦è‘—åãªå¥¥é‡Žå¹¹ä¹Ÿæ°ã«ã‚ˆã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’åŽéŒ²ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®ä¸€å†Šã§ã™ã€‚ æœ¬æ›¸ã¸ã®ç§°è³›ã®å£° ç›£è¨³è€…ã¾ãˆãŒã ã¯ã˜ã‚ã« Iéƒ¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–
stibbar 2013/01/19
æœ¬

æ›¸ç±

ã‚ªãƒ©ã‚¤ãƒªãƒ¼

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
è£MySQL ã‚¯ã‚¨ãƒªãƒ¼å…¥é–€ (1) ELTã¨FIELD - ã‚¤ãƒŽãƒ™ãƒ¼ãƒˆãªéžæ—¥å¸¸
ãƒ–ãƒã‚°ã‚³ãƒ³ãƒ†ã‚¹ãƒˆã‚‚çµ‚ã‚ã£ã¦ã—ã¾ã£ãŸã®ã§ã€MySQLã®å®Ÿè·µTIPSã‚’æ›¸ã„ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ä¸€èˆ¬çš„ãªSQLã®ä»–ã®ã‚µã‚¤ãƒˆã®è§£èª¬ã«è²ã‚‹ã¨ã—ã¦ã€ã¡ã‚‡ã£ã¨æ¨ªé“ã«ãã‚Œã¦ã€MySQLç‹¬è‡ªé–¢æ•°ã‚’ä½¿ã£ãŸå®Ÿè·µTIPSã‚’ç´¹ä»‹ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšç¬¬ä¸€å¼¾ã¯ã€ŽELT/FIELDã€ã€MySQLãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚€ã¨ ELT(N,str1,str2,str3,...) N = 1 ã®å ´åˆã¯ str1 ã‚’æˆ»ã—ã€N = 2 ã®å ´åˆã¯ str2 ã‚’æˆ»ã™ã€ã¨ã„ã†ãµã†ã«ç¶šãã¾ã™ã€‚N ãŒ 1 ä»¥ä¸‹ã‹ã€å¼•æ•°ã®æ•°ã‚ˆã‚Šå¤§ãã‘ã‚Œã°ã€NULL ã‚’æˆ»ã—ã¾ã™ã€‚ELT() ã¯ FIELD() ã®è£œæ•°ã§ã™ã€‚ã¨æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ãŒã“ã‚Œã ã‘ã ã¨è‰¯ãåˆ†ã‹ã‚Šã¾ã›ã‚“ã€‚ å…·ä½“çš„ãªå®Ÿè·µä¾‹ã‚’ã‚ã’ã‚‹ã¨ä¾‹ãˆã°ã€ãƒ¦ãƒ¼ã‚¶ãƒ†ãƒ¼ãƒ–ãƒ«(user)ã§ã€Žsexã€ã¨ã„ã†æ€§åˆ¥ã‚’ç¤ºã™ã‚«ãƒ©ãƒ ãŒã‚ã£ãŸã¨ã—ã¾ã™ã€1:ç”· 2:å¥³ã¨ã„ã£ãŸæ„å‘³ã§tinyintåž‹ã§å€¤ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã¨ã—ã¾ã™ã€‚ãã®
stibbar 2012/12/22
mysql

sql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€€ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ
ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¨ã„ã†SQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã€2010å¹´3æœˆã«IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼‰ã‹ã‚‰å…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã‚Œã¯2006å¹´1æœˆã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ã€Webã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…å‘ã‘ã®ã‚»ã‚ãƒ¥ã‚¢Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã®ãŸã‚ã®è³‡æ–™ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã®åˆ¥å†Šã¨ã—ã¦æ›¸ã‹ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ãŒ92ãƒšãƒ¼ã‚¸ãªã®ã«å¯¾ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã ã‘ã§40ãƒšãƒ¼ã‚¸ã‚‚ã®åˆ†é‡ãŒã‚ã‚‹ã€‚ãªãœã“ã‚“ãªã«åˆ†åŽšã„ã®ã ã‚ã†ã‹ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«å”åŠ›ã—ãŸã¨ã„ã†ã€ç‹¬ç«‹è¡Œæ”¿æ³•äººç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ‰€ æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ã®é«˜æœ¨æµ©å…‰æ°ã«ãŠè©±ã‚’ä¼ºã†ã“ã¨ãŒã§ããŸã€‚é«˜æœ¨æ°ã¯å€‹äººãƒ–ãƒã‚°ã€Œé«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ã€ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å•é¡Œã‚’è¿½æ±‚ã™ã‚‹è«–å®¢ã¨ã—ã¦ã‚‚çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç†è€…ã‚‚ä»¥å‰ã€ã“ã®é€£è¼‰ã®ã€Œä»Šå¤œã‚ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã®å›žï¼ˆ2006å¹´11æœˆ
stibbar 2010/06/26
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

RDBMS

SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
æ•™ãˆã¦ï¼ Watch updateã§ã¯insertã§ããªã„ï¼Ÿ
stibbar 2009/07/11
QA

è³ªå•

SQL
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸