[B! mysql] kero_mi_chanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kero_mi_chan id:kero_mi_chan

mysqlã«é–¢ã™ã‚‹kero_mi_chanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

ã€€debianã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦è¨å®šã™ã‚‹ - è¦‹æžœã¦ã¬å¤¢
debianã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸã®ã§ã€ä¸€å¿œçµŒéŽã‚’æ®‹ã—ã¦ãŠãã€‚debianã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯CDã‹ã‚‰è¡Œã„ã€ä»–ã®éƒ¨åˆ†ã‚‚å¤šãã¯åŒåƒšã«ã‚„ã£ã¦ã‚‚ã‚‰ã£ãŸã€‚MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«éƒ¨åˆ†ã‚‚ã‚„ã£ã¦ã‚‚ã‚‰ã£ãŸãŒã€ãã®å‰ã«ä¸€å¿œæ‰‹é †ã‚’è‡ªåˆ†ã§èª¿ã¹ã¦ã€ã‚„ã£ã¦ã‚‚ã‚‰ã£ãŸéƒ¨åˆ†ã‚‚è¦‹ã¦ã„ãŸã®ã§ã€è¨˜éŒ²ã€‚ä»Šåº¦ã€åƒ•ãŒå‰ã«ä½¿ã£ã¦ã„ãŸNECã®å¤ã„PCã§ã‚‚ã‚‚ã‚‰ã£ã¦ãã¦Linuxã®ç·´ç¿’ç”¨ã¨ã—ã¦å‹•ã‹ãã†ã‹ãªãã¨è¨ˆç”»ä¸ã€‚ ã¾ãšã¯MySQLã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã©ã‚Œã‚’ä½¿ã†ã‹ç¢ºèªã™ã‚‹ã€‚ debian:~# aptitude search mysqlã™ã‚‹ã¨ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ä¸€è¦§ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚MySQL5ã‚’ä½¿ã†ã®ã§ã€mysql-server-5.0ã‚’ä½¿ã†ã“ã¨ã«ã™ã‚‹ã€‚ä¸€å¿œã€ã‚‚ã†å°‘ã—æƒ…å ±ã‚’ç¢ºèªã—ãŸã„å ´åˆã¯ã€ debian:~# aptitude show mysql-server-5.0ã¨ã™ã‚‹ã¨ã€mysqlã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒmysql5.0.32-7etch6ã ã¨
kero_mi_chan 2013/06/15
ã‚„ã£ã¦ã¿ã‚ˆã†ã€‚

mysql

debian

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
mysqlã®Workbenchã§å®ŸDBã‹ã‚‰ERå›³ã‚’è‡ªå‹•ç”Ÿæˆ - end0tknr's kipple - webå†™çµŒé–‹ç™º
http://d.hatena.ne.jp/end0tknr/20100603/1275557645 ä»¥å‰ã€SQL::Translator ã«é–¢ã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã„ã¾ã™ãŒã€ã‚ã‚‹ç¨‹åº¦ã®è¦æ¨¡ã®DBã§ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®é–¢ä¿‚ã‚’ERå›³ç‰ã§æŠŠæ¡ã—ãŸã„ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã®å‘¨ã‚Šã§ã¯ã€ã€Œ1) visioã§ERå›³, excelã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€ã‚’ä½œæˆã—ã€æ›´ã«ã€Œ2)ã‚¨ãƒ‡ã‚£ã‚¿ã§DDL(sql)ã€ã‚’ä½œæˆã—ã¦ã„ã‚‹ã®ã§ã€ã€Œã“ã®1ã¨2ã‚’ã¾ã¨ã‚ã¦ä½œæ¥ã§ããªã„ã‹ãªãã€ãªã‚“ã¦æ€ã£ã¦ã„ãŸã‚‰ã€mysql.comãŒå‡ºã—ã¦ã„ã‚‹ã‚“ã§ã™ãã€‚ http://www-jp.mysql.com/products/workbench/ æ©Ÿèƒ½ä¸€è¦§ http://www-jp.mysql.com/products/workbench/features.html install (.netãŒå¿…è¦ã‹ã‚‚) å…ˆç¨‹ã®urlã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€ã‚¤ãƒ³ã‚¹
kero_mi_chan 2013/06/15
ä¾¿åˆ©ã ãã€‚

mysql

Workbench
ãƒªãƒ³ã‚¯
http://mirror.provenscaling.com/mysql/community/binaries/4.1/
kero_mi_chan 2013/03/14
ãƒªãƒ³ã‚¯åˆ‡ã‚Œã¦ã‚‹ã®ã§ã€‚

MySQL

4.1
ãƒªãƒ³ã‚¯
MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilviaâ€™s diary
MySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 ç‰ˆã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„å‘³ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„å‘³ã™ã‚‹ã€‚ã€Œé›»è©±ç•ªå·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’è¡¨ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ NULL å€¤ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
kero_mi_chan 2012/09/19
ã“ã‚Œã¯ãƒãƒžã‚‹ã§ã™ã‚ˆï¼

mysql

null

DB

sql

tips

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

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

database
ãƒªãƒ³ã‚¯
1