[B! MySQL] pero_0104ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

pero_0104 id:pero_0104

MySQLã«é–¢ã™ã‚‹pero_0104ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (115)

${{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}}

MySQL ã§ã¯ã€sysdate() ã§ã¯ãªãã€now()ã‚’ä½¿ã†ã®ãŒç„¡é›£ã‹ã‚‚
2008-09-11 ãã‚‚ãã‚‚ now() ã¨ sysdate() ã§ã¯ãªã«ãŒé•ã†ã®ã‹ï¼Ÿ 11.5. æ—¥ä»˜æ™‚åˆ»é–¢æ•° http://dev.mysql.com/doc/refman/5.1/ja/date-and-time-functions.html ã«ã‚ˆã‚‹ã¨ SYSDATE() ã¯ã€ãã‚ŒãŒå®Ÿè¡Œã•ã‚ŒãŸæ™‚é–“ã‚’æˆ»ã—ã¾ã™ã€‚ã“ã‚Œã¯ NOW() ã®å‹•ä½œã«ã‚ˆã£ã¦ç•°ãªã‚Šã€ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãŒå®Ÿè¡Œã‚’é–‹å§‹ã™ã‚‹æ™‚é–“ã‚’ç¤ºã™å®šæ•°æ™‚é–“ã‚’æˆ»ã—ã¾ã™ã€‚( ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ«ãƒ¼ãƒãƒ³ã¾ãŸã¯ãƒˆãƒªã‚¬å†…ã§ã€NOW() ã¯ãƒ«ãƒ¼ãƒãƒ³ã¾ãŸã¯ãƒˆãƒªã‚¬æ–‡ãŒå®Ÿè¡Œã‚’é–‹å§‹ã™ã‚‹æ™‚é–“ã‚’æˆ»ã—ã¾ã™ã€‚) ãã®ã»ã‹ã€ SET TIMESTAMP æ–‡ã¯ NOW() ã«ã‚ˆã£ã¦æˆ»ã•ã‚ŒãŸå€¤ã«å½±éŸ¿ã‚’åŠã¼ã—ã¾ã™ãŒã€SYSDATE() ã«ã‚ˆã£ã¦æˆ»ã•ã‚ŒãŸå€¤ã«ã¯å½±éŸ¿ã—ã¾ã›ã‚“ã€‚ã¤ã¾ã‚Šã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã®ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—è¨å®šã¯ã€SYSDATE() ã®å‘¼ã³å‡ºã—ã«ã¯åŠ¹æžœã‚’ã‚‚ãŸã‚‰ã•ãªã„ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾
pero_0104 2019/07/09
mysql
ãƒªãƒ³ã‚¯
MySQL ã®ã€ŒIncorrect string valueã€ã‚¨ãƒ©ãƒ¼ã‚’ç›´ã™ (ã‚µãƒã‚²ãƒ¼ãƒˆãƒšã‚¢ã«å¯¾å¿œã—ãŸ UTF8MB4 ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«å¤‰æ›´ã™ã‚‹) - Corredor
CentOS Linux ä¸Šã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸ MySQL ã§æ¤œè¨¼ã€‚ MySQL ã‚’ä½¿ã£ã¦ã„ã¦ã€çµµæ–‡å—ã‚’å«ã‚€ãƒ†ã‚ã‚¹ãƒˆã‚’ INSERTãƒ»UPDATE ã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã€‚ Incorrect string value: '\xF0\xA6\x9A\xB0\xE7\x94...' for column 'my_column' at row 1 èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ã©ã†ã‚‚ MySQL ã® utf8 ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¯ã‚µãƒã‚²ãƒ¼ãƒˆãƒšã‚¢æ–‡å—ã«å¯¾å¿œã—ã¦ã„ãªã„ã‚ˆã†ã§ã€çµµæ–‡å—ãªã©ã‚’æ‰±ã†ã«ã¯ã€ã‚µãƒã‚²ãƒ¼ãƒˆãƒšã‚¢æ–‡å—ã«å¯¾å¿œã—ãŸã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚° utf8mb4 ã«å¤‰ãˆãªã„ã¨ã„ã‘ãªã„ã¿ãŸã„ã€‚ å‚è€ƒï¼šMySQL Incorrect string value: ã®è§£æ±ºç– | ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ãƒŽãƒ¼ãƒˆ è¨å®šæ‰‹é †ã¯ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã©ãŠã‚Šã€‚ å‚è€ƒï¼šMySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’utf8mb4ã«å¤‰æ›´ - Qiita ã¾ãšã¯ DB ã®
pero_0104 2019/06/28
â€œALTER DATABASE ã€DB åã€‘ CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; -- ä»Šå¾Œæ–°ãŸã«ä½œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã—ç›´ã™ ALTER TABLE ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€‘ default character set utf8mb4; -- ä»Šã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’ç›´

mysql
ãƒªãƒ³ã‚¯
http://ftp.tcrc.edu.tw/MySQL/doc/refman/4.1/ja/cast-functions.html
pero_0104 2019/06/05
MySQL
ãƒªãƒ³ã‚¯
MySQLã§ã‚«ãƒ©ãƒ ã®å€¤ã‚’1å¢—ã‚„ã™æ–¹æ³• - ãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ç ”ç©¶å®¤
MySQLã®å€¤ã‚’1å¢—ã‚„ã™ï¼ˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã™ã‚‹ï¼‰æ–¹æ³•ã§ã™ã€‚ ãŸã¨ãˆã°ã€ãƒ–ãƒã‚°ã®è¨˜äº‹ã®ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆã‚¢ã‚¯ã‚»ã‚¹æ•°ï¼‰ã®ã‚«ã‚¦ãƒ³ãƒˆãªã©ã«ä½¿ãˆã¾ã™ã€‚ ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€articleã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã€idãŒ234ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã€ã‚«ãƒ©ãƒ ã®ï¼‘ã¤ã§ã‚ã‚‹pageviewã‚’1å¢—ã‚„ã—ã¦ã„ã¾ã™ã€‚ UPDATE article SET pageview = pageview + 1 WHERE id = 234;
pero_0104 2019/06/05
mysql
ãƒªãƒ³ã‚¯
MySQLã§æ¡ãŒè¶³ã‚Šãªã„åˆ†ã‚’ï¼ã§åŸ‹ã‚ã‚‹ - Qiita
### ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚ mysql> create table demo(id serial primary key, n integer not null); Query OK, 0 rows affected (0.02 sec) ### ã¨ã‚Šã‚ãˆãšï¼“ä»¶ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã€‚ mysql> insert into demo(n) values(1); Query OK, 1 row affected (0.00 sec) mysql> insert into demo(n) values(2); Query OK, 1 row affected (0.00 sec) mysql> insert into demo(n) values(300); Query OK, 1 row affected (0.00 sec) ### 3æ¡ 0åŸ‹ã‚ mysql> select lpad(n, 3, '0
pero_0104 2019/06/05
â€œlpad(n, 2, 0)â€

qiita

mysql
ãƒªãƒ³ã‚¯
ã€MySQLã€‘ç…§åˆé †åºã¨ã¯ï¼Ÿ - Qiita
##ç…§åˆé †åºã¨ã¯ï¼Ÿ MySQLã¯æ–‡å—ã‚³ãƒ¼ãƒ‰ã¨ã‚½ãƒ¼ãƒˆé †ã‚’æŒã£ã¦ã„ã¦ã€ã‚½ãƒ¼ãƒˆé †ã®éƒ¨åˆ†ãŒCollationã¨ã‚ˆã°ã‚Œã¦ã„ã‚‹ã€‚(æ–‡å—ã‚³ãƒ¼ãƒ‰ã®éƒ¨åˆ†ã¯Character Set) æ¯”è¼ƒã™ã‚‹ã¨ãã«ã¯æ–‡å—ã‚³ãƒ¼ãƒ‰ã ã‘ã§ãªãã¦CollationãŒä¸€è‡´ã™ã‚‹ã‹ã©ã†ã‹ã‚’æ¯”è¼ƒã™ã‚‹(é †åºãŒåˆã‚ãªã„ã¨æ¯”è¼ƒã§ããªã„)ã€‚ ã®ã§ã€JOINã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã€‚ DBå˜ä½ã€ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã€ã‚«ãƒ©ãƒ å˜ä½ã§è¨å®šå¯èƒ½ã€‚ ##ç…§åˆé †åºã®æ„å‘³ ä¾‹ãˆã° cp932_japanese_ci ã®ã‚ˆã†ãªCollationã®å ´åˆã€‚ æ–‡å—ã‚³ãƒ¼ãƒ‰: cp932 utf8ã¨ã‹cp932ã¨ã‹ã®character setã®äº‹ã€‚ è¨€èªžå: japanese japaneseã‚„thaiã‚„generalã€unicodeãªã©ãŒå…¥ã‚Šã¾ã™ã€‚ generalã‚„unicodeã¯ãƒžãƒ«ãƒãƒªãƒ³ã‚¬ãƒ«ã®äº‹(utf8ã«japaneseã¯ãªã„)ã€‚ æ¯”è¼ƒæ³•: ci _ciã€_csã€_bin
pero_0104 2019/05/23
mysql

qiita
ãƒªãƒ³ã‚¯
https://4to.pics/article/post/116
pero_0104 2019/05/22
mysql

+åŠ©ã‹ã£ãŸ
ãƒªãƒ³ã‚¯
MySQLã®ã‚½ãƒ¼ãƒˆã§ç©ºç™½ã®è¡Œã‚’ä¸‹ã’ã‚ˆã†ã¨ã—ãŸã‚‰ãƒãƒžã£ãŸè©± | MySQL | æŠ€è¡“ | AyumiFolio
MySQLã®ã‚½ãƒ¼ãƒˆã§å°‘ã€…ãƒãƒžã‚Šã¾ã—ãŸã€‚åŒã˜é–“é•ã„ã‚’ã—ãªã„ç‚ºã«è¨˜éŒ²ã—ã¦ãŠãã¾ã™ã€‚ ã‚„ã‚ŠãŸã‹ã£ãŸäº‹ ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãŒã‚ã£ãŸã¨ã—ã¾ã—ã‚‡ã†ã€‚ +----+--------+------+------------------+ | id | name | age | code | +----+--------+------+------------------+ | 1 | Taro | 25 | bx8m9xfhx7med7ep | | 2 | Jiro | 25 | hitnskx5kcx8cswf | | 3 | Saburo | 25 | | | 4 | Siro | | dddtwr6ses7ih2ai | | 5 | Goro | | | | 6 | Roro | 26 | | +----+--------+------+------------------+ æœŸå¾…ã—ã¦ã„ãŸã‚½ãƒ¼ãƒˆæ¡ä»¶
pero_0104 2019/05/21
mysql
ãƒªãƒ³ã‚¯
ã€Žã€MySQLã€‘é€£ç•ªã‚’æŒ¯ã‚ŠãªãŠã™ã€
æ„›çŸ¥çœŒä¸€å®®å¸‚ã«ã‚ã‚‹ã®ãŒã€ ã‚ãŸã—ãŸã¡ã®ã€Œæ ªå¼ä¼šç¤¾ã‚¨ã‚¹ãƒ—ãƒªã€ã§ã™ã€‚ ã‚ãŸã—ãŸã¡ã®ä»•äº‹ã¶ã‚Šã ã‘ã§ãªãã€ æ—¥å¸¸ã‚’ã”è¦§ãã ã•ã„ã€‚ MySQLã§ãƒ‡ãƒ¼ã‚¿ã‚’æ•´ç†ã—ãŸã„æ™‚ã«ä¾¿åˆ©ãªSQLã®ãƒ¡ãƒ¢ SET @i := 0; UPDATE ãƒ†ãƒ¼ãƒ–ãƒ«å SET ã‚«ãƒ©ãƒ å = (@i := @i +1); 1è¡Œç›®ã§æŒ‡å®šã—ãŸæ•°å€¤+1ã‹ã‚‰ç•ªå·ãŒæŒ¯ã‚‰ã‚Œã‚‹ã®ã§ã€ä¸Šè¨˜ã®ä¾‹ã§ã¯1ã‹ã‚‰é€£ç•ªãŒæŒ¯ã‚‰ã‚Œã¾ã™ã€‚ UPDATE ãƒ†ãƒ¼ãƒ–ãƒ«å SET ã‚«ãƒ©ãƒ A = (@i := @i +1) ORDER BY ã‚«ãƒ©ãƒ B DESC; ORDERå¥ã‚’ä½¿ç”¨ã—ã¦ä¸¦ã³é †ã‚’æŒ‡å®šã—ã¦é€£ç•ªã‚’æŒ¯ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚
pero_0104 2019/05/08
ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€ã¨ã¦ã‚‚åŠ©ã‹ã‚Šã¾ã—ãŸ

mysql

SQL

+åŠ©ã‹ã£ãŸ
ãƒªãƒ³ã‚¯
ã€MySQLã€‘æ—¥ä»˜åž‹ã‚’ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã™ã‚‹Â 030_ç”£æ¥ã‚·ã‚¹ãƒ†ãƒ éƒ¨|Â ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ–ãƒã‚°(ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ã‚¢ã‚¤ãƒãƒ™ãƒƒã‚¯ã‚¹ï½œæ±äº¬éƒ½ä¸å¤®åŒºã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºä¼šç¤¾)
ã¿ãªã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ã€‚ ç”£æ¥ã‚·ã‚¹ãƒ†ãƒ éƒ¨ã®é’æœ¨ã§ã™ã€‚ MySQLã§æ—¥ä»˜åž‹ã‚’ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã™ã‚‹ã«ã¯DATE_FORMATé–¢æ•°ã‚’ä½¿ã„ã¾ã™ã€‚ -- %Yï¼šå¹´ï¼ˆ4æ¡ï¼‰ %mï¼šæœˆï¼ˆ0åŸ‹ã‚ï¼‰ %dï¼šæ—¥ï¼ˆ0åŸ‹ã‚ï¼‰ SELECT DATE_FORMAT('20100101', '%Y%m%d') -- 2010/01/01 -- %yï¼šå¹´ï¼ˆ2æ¡ï¼‰ %cï¼šæœˆï¼ˆ0åŸ‹ã‚ãªã—ï¼‰ %eï¼šæ—¥ï¼ˆ0åŸ‹ã‚ãªã—ï¼‰ SELECT DATE_FORMAT('20100101', '%y/%c/%e') -- 10/1/1 -- %Hï¼šæ™‚é–“ï¼ˆ0åŸ‹ã‚ã®24æ™‚é–“ï¼‰ %iï¼šåˆ† %Sï¼šç§’ SELECT DATE_FORMAT('2010-01-01 23:01:01', '%H:%i:%S') -- 23:01:01 SELECT DATE_FORMAT('2010-01-01 01:01:01', '%H:%i:%S') -- 01:01:
pero_0104 2019/05/08
â€œ%H:%i:%Sâ€

mysql
ãƒªãƒ³ã‚¯
MySQLã§æ—¥æœ¬èªžãŒæ–‡å—åŒ–ã‘ã—ã¦ã—ã¾ã†ã¨ãã®å¯¾å‡¦æ–¹æ³•
MySQLã‚’ä½¿ã£ã¦è‰¯ãã‚„ã‚‰ã‹ã™ãƒŸã‚¹ã®ä¸€ã¤ã¨ã—ã¦ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è¨å®šãƒŸã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ MySQLã®å ´åˆã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾åˆ©ç”¨ã™ã‚‹ã¨ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„dbãŒæ„å›³ã—ã¦ã„ãªã„æ–‡å—ã‚³ãƒ¼ãƒ‰(ä¾‹ãˆã°latin1)ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®çŠ¶æ…‹ã§selectãªã©ã§æ—¥æœ¬èªžã‚’å–ã‚Šå‡ºãã†ã¨ã™ã‚‹ã¨æ–‡å—åŒ–ã‘ã—ã¦ã—ã¾ã„ã€â€??????â€ã®ã‚ˆã†ãªæ–‡å—åˆ—ã«ç½®ãæ›ã‚ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ä½¿ã£ã¦ã„ã‚‹MySQLã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ç¢ºèªã™ã‚‹ã«ã¯ã€SQLæ–‡ã‚’ show variables like 'character%'; ã¨ã—ã¾ã™ã€‚ã™ã‚‹ã¨ mysql> show variables like 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +------------------
pero_0104 2019/04/19
mysql
ãƒªãƒ³ã‚¯
ã€å‚™å¿˜éŒ²ã€‘MySQLå§‹ã‚ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ—¥æœ¬èªžã„ã‚Œã‚ˆã†ã¨ã—ãŸã‚‰ãƒãƒžã£ãŸ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
pero_0104 2019/04/19
mysql

qiita
ãƒªãƒ³ã‚¯
SQLServerã«æ—¥æœ¬èªžãƒ‡ãƒ¼ã‚¿ã‚’Insertã™ã‚‹ã¨æ–‡å—åŒ–ã‘ã™ã‚‹ã€‚ - lycheejam's tech log
æ¦‚è¦ ã‚¿ã‚¤ãƒˆãƒ«ã¾ã‚“ã¾ã§ã™ã€‚ SQLServerã«æ—¥æœ¬èªžãƒ‡ãƒ¼ã‚¿ã‚’Insertã™ã‚‹ã¨æ–‡å—åŒ–ã‘ã—ã¦ã€Œ??????ã€ã¨è¨€ã£ãŸé¢¨ã«ãªã‚Šã¾ã™ã€‚ è§£æ±ºã—ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ç›®æ¬¡ æ¦‚è¦ ç›®æ¬¡ ç’°å¢ƒ ç”ŸSQLã§Insert æ–‡å—åŒ–ã‘ã—ãŸ æ–‡å—åŒ–ã‘è§£æ±º å‚è€ƒã‚µã‚¤ãƒˆæ§˜ é›‘æ„Ÿ ç’°å¢ƒ Windows 10 Pro Ver 1709 Microsoft SQL Server Express Edition (64-bit) (SQL Server Data Tools 15.1.61804.210) A5:SQL Mk2 Version 2.12.3 (64bit) ç”ŸSQLã§Insert æ–‡å—åŒ–ã‘ã—ãŸ æ™®æ®µã€LINQ to Entitiesã§ãƒ‡ãƒ¼ã‚¿ã®CRUDã‚’ã‚„ã£ã¦ã‚‹æ„Ÿã˜ãªã‚“ã§ã™ãŒ ç”Ÿã®SQLæ–‡ã§Insertã—ãŸããªã£ãŸã®ã§ã‚„ã£ã¦ã¿ãŸã‚‰æ–‡å—åŒ–ã‘ã—ã¾ã—ãŸã€‚ ä»¶ã®æ–‡å—åŒ–ã‘SQLã¨å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¸‹è¨˜ã®é€šã‚Šã€‚ INSERT IN
pero_0104 2019/04/19
mysql

SQL Server
ãƒªãƒ³ã‚¯
ã€WordPressã€‘DBã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ã®ã‚¨ãƒ©ãƒ¼ãŒã§ãŸã¨ãã®å¯¾å‡¦æ³•ãƒ¡ãƒ¢ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
pero_0104 2019/04/19
mysql

qiita
ãƒªãƒ³ã‚¯
SQL Serverã®Nãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ - trapemiyaã®æ—¥è¨˜
ä»Šã‹ã‚‰ç´„ï¼‘ï¼å¹´ã»ã©å‰ã«ã€SQL Serverã®Nãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦æ—§MSDNãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã«æŠ•ç¨¿ã—ã¾ã—ãŸãŒã€ä»Šã¯ã‚¢ã‚¯ã‚»ã‚¹ã§ããªããªã£ã¦ã„ã¾ã™ã®ã§ã€ä»¥ä¸‹ã«è¼‰ã›ã¦ãŠãã¾ã™ã€‚å½“æ™‚ã®åŽŸæ–‡ã®ã¾ã¾ã§ã™ã€‚ãªãŠã€å½“æ™‚ã®ç§ã®ãƒãƒ³ãƒ‰ãƒ«åã¯MIYAã§ã—ãŸã€‚ ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ MIYA å‚åŠ æ—¥: 2003-5-6 æŠ•ç¨¿æ•°: 1641 Re: SqlServerã§ã®æ—¥æœ¬èªžå®šæ•°ã®ä½¿ç”¨ æŠ•ç¨¿æ—¥æ™‚: 2004-11-14 åˆå¾Œ 6:07 ã“ã‚“ã«ã¡ã¯ã€‚MIYAã§ã™ã€‚ ï¼ˆä»¥ä¸‹ã®æ–‡ã«ã¤ã„ã¦ã€ç§ã‚‚ï¼‘ï¼ï¼ï¼…ã®è‡ªä¿¡ãŒã‚ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã„ã‚ã„ã‚ãªè¨˜äº‹ã€ãŠã‚ˆã³çµŒé¨“ã‹ã‚‰ç·åˆçš„ã«ç§ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ç†è§£ã—ã¦ã„ã¾ã™ã€‚èª¤ã‚ŠãŒã‚ã‚Œã°ã”æŒ‡æ‘˜ãã ã•ã„ã€‚(^^;ï¼‰ æ—¥æœ¬ã§æ™®é€šã«SQLserverã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå ´åˆã€SQLserverã«ãŠã‘ã‚‹æ—¢å®šã®ã‚³ãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã¯japanese(ã‚³ãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸932ã€ä»¥ä¸‹CP932ï¼‰ã§ã™ã€‚ã“
pero_0104 2019/04/19
ã„ã‚„ã€ã¤ã‘ã¦ãã ã•ã„ã¤ã‘ã¦ãã ã•ã„ã£ã¦ã‚ãªãŸâ€¦Nãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã£ã¦ãªã«ã‚ˆã©ã†ã‚„ã£ã¦ã¤ã‘ã‚‹ã®ã‹

mysql

SQL Server
ãƒªãƒ³ã‚¯
MySQL Workbenchã®ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚’è¦šãˆã¦ä½œæ¥åŠ¹çŽ‡ã‚¢ãƒƒãƒ— | ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ãƒŠãƒ“ by Proglusï¼ˆãƒ—ãƒã‚°ãƒ©ã‚¹ï¼‰
MySQL Workbenchã®ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ ã«ã¤ã„ã¦ã€åˆå¿ƒè€…å‘ã‘ã«èª¬æ˜Žã„ãŸã—ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³è¬›åº§ã€Œã¯ã˜ã‚ã¦ã®SQLãƒ»ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ â€“ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ã‚½ãƒ³ãŒç¾å ´ã§æ´»ç”¨ã™ã‚‹ãŸã‚ã®SQLåˆå¿ƒè€…å‘ã‚³ãƒ¼ã‚¹ã€ã®ã‚µãƒãƒ¼ãƒˆè¨˜äº‹ã§ã™ã€‚ å‹•ç”»ã§å¦ç¿’ 1ä»¶ã®SQLã‚’å®Ÿè¡Œ macOS : command + enter Windows : ctrl + enter ã‚«ãƒ¼ã‚½ãƒ«ç›´å‰ã®1ä»¶ã«ã¤ã„ã¦ã€SQLãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ ã™ã¹ã¦ã®SQLã‚’å®Ÿè¡Œ macOS : command + shift + enter Windows : ctrl + shift + enter ã‚¨ãƒ‡ã‚£ã‚¿ã«è¨˜è¿°ã—ãŸSQLãŒã™ã¹ã¦å®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ æ„å›³ã—ãªã„SQLãŒå®Ÿè¡Œã•ã‚Œãªã„ã‚ˆã†ã«æ³¨æ„ã—ã¾ã—ã‚‡ã†ã€‚ é¸æŠžã—ãŸSQLã‚’å®Ÿè¡Œ å®Ÿè¡Œã—ãŸã„SQLã‚’é¸æŠžã—ãŸä¸Šã§ã€ macOS : command + shift +
pero_0104 2019/04/16
mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¨ãƒ©ãƒ¼ã€ŒError Code: 1175ã€ã®å¯¾å‡¦æ–¹æ³•
MySQLã«ã¦SQLã§ä¸€æ‹¬ç½®æ›ã‚’ã—Updateã‚’ã‹ã‘ã‚ˆã†ã¨æ€ã£ãŸã‚‰ã€ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¾ã—ãŸã€‚ Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect. ãƒ¡ãƒ¢ã¨ã—ã¦ã“ã®ã‚¨ãƒ©ãƒ¼ã®åŽŸå› ã¨å¯¾å‡¦æ–¹æ³•ã‚’è¨˜è¼‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ å‰ææ¡ä»¶ åŽŸå› å¯¾å¿œæ–¹æ³• å‚è€ƒæ–‡çŒ® å‰ææ¡ä»¶ MySQL 5.5.XX Windows XP åŽŸå› åŽŸå› ã¯MySQLã®æŽ¥ç¶šã™ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®è¨å®šé …ç›®ã€ŒSQL_SAFE_UPDATESã€ãŒ1ã«ãªã£ã¦ã„ã‚‹ç‚ºã§ã™ã€‚ MySQLã®ãƒªãƒ•ã‚¡
pero_0104 2019/04/16
â€œSET SQL_SAFE_UPDATES = 0;â€

mysql
ãƒªãƒ³ã‚¯
mysqlã®äºˆç´„èªžã§ãƒãƒžã£ãŸ - KAYAC Engineers' Blog
ã„ã¤ã ã£ã¦ãŠã‚‚ã—ã‚ã„äº‹ã‚’è€ƒãˆã¦ã„ã‚‹ãƒ ã‚«ã‚¤ã§ã™ã€‚ ã¨ã¦ã‚‚ç°¡å˜ã«æ‰±ãˆã¦ä¾¿åˆ©ãªmysqlã€‚ ã—ã‹ã—ãã‚“ãªæ¥½ã—ã„mysqlã«ã‚‚äºˆç´„èªžã¨ã„ã†ç½ ï¼ˆï¼Ÿï¼‰ãŒæ½œã‚“ã§ã„ã¾ã™ å…ˆæ—¥ã€mysqlã§è»½ãDBã‚’ä½œã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚ˆã†ã¨ã—ãŸæ™‚ã€ã¾ã£ãŸãinsertãŒã§ããªã„äº‹æ…‹ã«é™¥ã‚Šã¾ã—ãŸã€‚ ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unique, sentence, url, deleted_at, created_at) VALUES ('9f075c89e1ce5c08cea7',' at line 1 ãªã‚“ã§ãªã‚“ã§ã¨èª¿ã¹ãŸçµæžœã€ç”ãˆã¯ã€Œäºˆç´„èªžã€ã§ã—
pero_0104 2019/04/11
äºˆç´„èªž

mysql
ãƒªãƒ³ã‚¯
MySQL Connector/.NET ã® TreatTinyAsBoolean ã®ãƒã‚°ã¨ Dapper - ã‚¢ã‚¸ãƒ§ãƒ–ã‚¸æ˜Ÿé€šä¿¡
MySQL Connector/.NETã€é•·ã„ã®ã§ MySql.Data ã¨å‘¼ã³ã¾ã™ã€‚ ãƒã‚°ã«ã¤ã„ã¦ MySql.Data ã®æŽ¥ç¶šæ–‡å—åˆ—ã§ä½¿ç”¨ã§ãã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã€ã€ŒTreatTinyAsBooleanã€ã¾ãŸã¯ã€ŒTreat Tiny As Booleanã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã¦ã€ã“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒæœ‰åŠ¹ã®ã¨ãã¯ TINYINT(1) ã®ã‚«ãƒ©ãƒ ã‚’ Boolean åž‹ã¨ã—ã¦æ‰±ã„ã¾ã™ã€‚ ã§ã€å¸¸ã« Boolean ã¨ã—ã¦æ‰±ã£ã¦ãã‚Œã‚‹ã‹ã¨ã„ã†ã¨ãã†ã§ã¯ãªã„ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ TINYINT(1) åž‹ã®ã‚«ãƒ©ãƒ ã« null ãŒå…¥ã£ã¦ã„ã‚‹ã¨ã€ãã‚Œä»¥é™ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯ Boolean ã§ã¯ãªã SByte ã«ãªã‚Šã¾ã™ã€‚ã“ã‚Œã«ã‚ˆã£ã¦ã‚ã‚ŠãŒãŸè¿·æƒ‘ãªæ©Ÿèƒ½ã‹ã‚‰ã€ãŸã ã®è¿·æƒ‘ãªæ©Ÿèƒ½ã«æ˜‡æ ¼ã—ã¾ã—ãŸãã€‚ãŠã‚ã§ã¨ã†ã€‚ å†ç¾ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚é©å½“ãª MySQL ã‚µãƒ¼ãƒãƒ¼ã‚’ç”¨æ„ã—ã¦ãˆã„ã£ã¨ã€‚ã¨ã“ã‚ã§
pero_0104 2019/04/11
MySQL
ãƒªãƒ³ã‚¯
ã€MySQLã€‘dateåž‹ã¨timeåž‹ã«åˆ†ã‘ã‚‰ã‚ŒãŸã‚«ãƒ©ãƒ ã‚’çµåˆã™ã‚‹æ–¹æ³• - Qiita
SELECT date_add(CAST([TRANSACTIONDATE] AS DATETIME), INTERVAL [TRANSACTIONTIME] HOUR_SECOND) FROM table; æ‰‹é †(è€ƒãˆæ–¹) 1 dateåž‹ã§å®šç¾©ã•ã‚ŒãŸã‚«ãƒ©ãƒ ã‚’datetimeåž‹ã«å¤‰æ›ã™ã‚‹ (2018-01-11 -> 2018-01-11 00:00:00) 1 datetimeåž‹ã«å¤‰æ›ã—ãŸã‚«ãƒ©ãƒ å€¤ã«ã€timeåž‹ã®ã‚«ãƒ©ãƒ ã®å€¤ã‚’åŠ ç®—ã™ã‚‹ (date_addé–¢æ•°) unit å€¤ã”ã¨ã«è¦æ±‚ã•ã‚Œã‚‹å½¢å¼ã® expr å¼•æ•° â€» expr = æ–‡å—åˆ— unit = å¼ã‚’è§£é‡ˆã™ã‚‹éš›ã®å˜ä½ã‚’ç¤ºã™ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ unitå€¤ è¦æ±‚ã•ã‚Œã‚‹ expr æ›¸å¼
pero_0104 2019/04/11
mysql

+åŠ©ã‹ã£ãŸ

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 æ¬¡ã®ãƒšãƒ¼ã‚¸