ä»åã¯ä¹ ãã¶ãã«MySQLã«é¢ããèšäºã§ãã
MySQLã®åºæ¬æ§æã«ã€ããŠã
é£èŒåã§è§£èª¬ããŠããããšæããŸãã
ãŸãååã¯ãMySQLãèµ·åããŠåããŠäœ¿ãã³ãã³ããšèšã£ãŠã
éèšã§ã¯ãªãã
ãshowã³ãã³ããã«ã€ããŠè§£èª¬ããŸãã
åèæžãªã©ã®æžç±ãªããã§ã¯
çãããŠããŸã£ãŠãããã¿ãŒã³ããããŸããã
ãšãŠã䟿å©ãªã³ãã³ãã§ãããããã²äœ¿ãããªããŠãã ããã
Youtubeãã£ã³ãã«ã«ããŸããŸãªåç»ãäžããŠããŸãã
âââãã¡ãããYoutubeãã£ã³ãã«ã«ã¢ã¯ã»ã¹!! âââ
æ¬ããã°ã¯ã¢ãã£ãªãšã€ããçšããåºåãæ²èŒããŠããŸãã
ããããMySQLã®ããŒãã«ãšãããŒã¿ããŒã¹ã£ãŠäœïŒïŒ
åºæ¬çãªå
容ã§ããã
ã¡ãã£ãšå¿ããŠããŸã£ãå Žåçšã«ã
以å解説ããèšäºããããŸãã
ããå¿ããŠããŸã£ãããã¡ãã®èšäºãåèã«ããŠã¿ãŠãã ããã
MySQLã®showã³ãã³ããšã¯ïŒ
showã³ãã³ãã§ã§ããããšã«ã€ããŠã¯ã
以äžã®ç« ã§è©³ãã解説ããŠãããŸãã
showã³ãã³ãã®å®éã®äœ¿ãæ¹ã¯ïŒ
showã³ãã³ãã®å®éã®äœ¿ãæ¹ãã玹ä»ããŸãã
æ§æãšããŠã¯ãã®2ã€ãæŒãããããŠããã°OKã§ãã
show databases;
show tables;
ããããã«ã€ããŠè©³ãã解説ããŠãããŸãããã
show databases;ãã®äœ¿ãæ¹ã
ãŸã泚æç¹ããã話ããŸããã
show database;ã§ã¯ãªããè€æ°åœ¢ã§ãshow databases;
ãšããªããšã³ãã³ããééã£ãŠããŸãã®ã§ãšã©ãŒãšãªããŸãã
ãšã©ãŒå
容ãšããŠã¯ãããªæãã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image.png)
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 ‘database’ at line 1
show database;ã§çºçãããšã©ãŒå 容ããã
èŠããã«databaseãšããã®ã¯èª€ããªã®ã§ãšã©ãŒã§ããšæããŠãããŠããããã§ãã
ã§ã¯æ³šæç¹ã®èª¬æãçµãã£ããšããã§ã
å®éã«åæç¶æ
ã®MySQLã€ã³ã¹ããŒã«çŽåŸã®ç¶æ
ã®
ããŒã¿ããŒã¹ã«ã¢ã¯ã»ã¹ããŠshowã³ãã³ãã䜿ã£ãŠã¿ãŸãããã
ãŸãã¯ãã°ã€ã³ããŠããã
show databases;
ãšæã¡èŸŒãã§ãšã³ã¿ãŒããŒãæŒããŸãã
ãããšããããªæãã§ããã©ã«ãã§ããªã€ã³ã¹ããŒã«ãããããŒã¿ããŒã¹ã衚瀺ãããŸãã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image-1.png)
åèš6åã®ããŒã¿ããŒã¹ãããªã€ã³ã¹ããŒã«ãããŠãããšããããšãããããŸãã
ãã®ããã§ãäŸãã°worldã«ã©ããªããŒãã«ãå
¥ã£ãŠãããïŒïŒ
確èªããŠã¿ãããªããŸãããïŒ
ãããã§ããã®ãshow tables;ã§ãã
次ã®ç« ã§è§£èª¬ããŸãã
show tables;ãã®äœ¿ãæ¹ã
show databases; ã®äœ¿ãæ¹ãããã£ããšããã§ã
ä»åºŠã¯show tables; ã®äœ¿ãæ¹ã§ãã
show tables; ã¯ãshow databases;ããšåæ§ã
show tables; ãšè€æ°åœ¢ã«ãªãããšã«æ³šæãå¿
èŠã§ãã
ãŸããshow databases; ãšç°ãªãã
ã©ã®ããŒã¿ããŒã¹ã®ããŒã¿ããŒãã«ã確èªãããã®ãïŒ
ãšããåŠçãã¯ã³ã¯ãã·ã§ã³å
¥ããŸãã
å ·äœçã«ã¯ã2éãã®ããæ¹ããããŸãã
â ããŒã¿ããŒã¹ãæå®ããŠuseã³ãã³ãã§éžæããæ¹æ³ã
ãŸãäžã€ç®ã®æ¹æ³ã§ããã
äŸãã°ãå
ã»ã©ã®ããŒã¿ããŒã¹ã®äŸã§ãããšã
6åã®ããŒã¿ããŒã¹ãååšããŠããŠã
ããããã®ããŒã¿ããŒã¹ã«ããŒã¿ããŒãã«ãååšããŠããŸãã
ã§ããããåçŽã«
show tables;ãšæã¡èŸŒãã§ãã
ã©ã®ããŒã¿ããŒã¹ã®ããŒã¿ããŒãã«ã確èªãããã®ã
ããœã³ã³åŽãïŒïŒïŒïŒãšãªãããã§ããã
ã§ãããã
ãã£ããã調ã¹ããããŒã¿ããŒã¹ãéžæããŸãããã
ãã®æ¹æ³ãã
use ããŒã¿ããŒã¹å
ããã ãã§ãã
äŸãã°å
ã»ã©show databases; ã§åºããäžããã
worldãéžæãããšããŸãããã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image-1.png)
ãããšããããªããŸãã
use world
ãã®ã³ãã³ããæã¡èŸŒãããšã§ã
Database changed
ãšè¡šç€ºãããç¡äºã«worldã®ããŒã¿ããŒã¹ãéžæããç¶æ
ã«ãªããŸãã
ãã®åŸãshow tables;ãšæã¡èŸŒãããšã§ã
worldã®äžã«ã©ããªããŒã¿ããŒãã«ãæ ŒçŽãããŠããã®ã確èªã§ããŸãã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image-2.png)
â¡in å¥ã䜵çšããããšã§ãããŒã¿ããŒã¹åãæå®ããæ¹æ³ã
次ã«show tables;ã䜿ãæ¹æ³ãšããŠçŽ¹ä»ããã®ã¯ã
ã in ãå¥ã䜿çšããæ¹æ³ã§ãã
å
ã»ã©use ã³ãã³ãã䜿çšããŠã
確èªãããããŒã¿ããŒã¹ãéžæããç¶æ
ã§
show tables;ãšæã£ãŠããŸããããïŒ
ãã ããã®ã in ãå¥ã䜿ãããšã§ã
ãªããšuse ã³ãã³ãã䜿çšããã«1è¡ã§ããŒã¿ããŒãã«åã®
ååŸãå¯èœã«ãªããŸãã
æ§æãšããŠã¯ããã§ãã
show tables in ããŒã¿ããŒã¹å;
ç¹ã«é£ãããªãã§ããã
äŸãã°å
ã»ã©ã®6åã®ããŒã¿ããŒã¹ããã
worldã®ããŒã¿ããŒãã«ã®å
容ã確èªããããã°ããããªããŸãã
show tables in world;
useã³ãã³ãã䜿ã£ãŠããããããŒã¿ããŒã¹ãéžæããªããŠã
è¯ããšããã¯ã¡ãªããã§ããã
ãã ããã®åŸæå®ã®ããŒã¿ããŒã¹ã§åŠçãç¡ããã°….ãšããæ¡ä»¶ä»ãã§ãã…ã
ã¡ãªã¿ã«ã§ãããin å¥ã®ä»£ããã«from å¥ã§ãåãåäœãããŸãã
showã³ãã³ãã®äœ¿ãéã¯ïŒ
äŸãã°ãããŒã¿ããŒã¹ã«rootã§ãã°ã€ã³ããçŽåŸã®ç¶æ
ãšããŸãã
ãããšãåããŠè§ŠãããŒã¿ããŒã¹ãªããã¯ç¹ã«ã§ããã
ã©ããªããŒã¿ããŒã¹ãã©ããªååã§ååšããŠãããããããŸãããã
ãããªæã
ãã©ããªããŒã¿ããŒã¹ãããã®ãïŒãããã©ããªããŒã¿ããŒãã«ãããã®ãïŒã
ããã«èª¿ã¹ãããªããŸãããã
ãã®show ã³ãã³ããããã°ã
ãšããããã®çŸåšååšããŠããããŒã¿ããŒã¹ãšããŒã¿ããŒãã«ã®ååã確èªã§ããŸãã
䜿ãéãšããŠã¯ç¢ºèªãäž»ã§ããã
ã¡ãã£ãšå¿çšãããŒãã«ã®ã«ã©ã å±æ§ã調ã¹ãæ¹æ³ã
show ã³ãã³ãã¯ããŒã¿ããŒã¹ã®ååãããŒã¿ããŒãã«ã®ååã
衚瀺ããŸããããå®ã¯ããŒã¿ããŒãã«ã®ã«ã©ã å±æ§ãäžçºã§èª¿ã¹ãããšãã§ããŸãã
ã«ã©ã å±æ§ã¯ãããã暪åã®äžŠã³ã®çš®é¡ã«ã€ããŠã§ãã
å®éã«ã¢ããèŠãã»ããæ©ããšæããŸãã®ã§ãã£ãŠã¿ãŸãããã
ãŸããæ§æã¯ãã¡ãã
show columns from ããŒãã«å;
å
è¿°ã®éããuse ããŒã¿ããŒã¹å;
ã§æ¢ã«worldãéžæããç¶æ
ã ãšéçšããŠã話ããŠãããŸãã
worldãšããããŒã¿ããŒã¹ã«ã¯ã
3ã€ã®ããŒã¿ããŒãã«ãååšããŠããŸããã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image-2.png)
ã§ã¯ããã®äžã®ãcityãšããããŒãã«ã
ãã¡ããã©ããªæ§æã®ããŒã¿ããŒãã«ãªã®ã調ã¹ãŠã¿ãŸãããã
ã³ãã³ããšããŠã¯ããã§ãã
show columns from city;
ãããããšããã®ãããªåœ¢ã§cityã®äžèº«ã®å±æ§ãããããŸãã
![](https://www.hobbyhappyblog.jp/wp-content/uploads/2023/07/image-3.png)
ãšããããä»ã®æç¹ã§ã¯ãFieldãããèŠãŠããã°OKã§ãã
TypeãNullãªã©ã¯ä»åŸã®èšäºã§è§£èª¬äºå®ã§ãã
ãã®ããã«show columnsãšããããšã§ã次ã«cityã«ããŒã¿ãæ ŒçŽããããšãããšãã«ã
ãã®åœ¢åŒéãã§ããã°æ ŒçŽã§ããããšããããšã«ãªããŸãã
ä»åã®ãŸãšãã
ä»å解説ããå 容ãããããããŸãã
ããŒã¿ããŒã¹ã«æ¥ç¶ã§ããã¯ãããã®ã®ã
ããããäœãã©ãããããããããããªã….
ãšããå Žåã¯ããšããããshowã³ãã³ããã€ãã£ãŠã
ããããªæ
å ±ãèŠãŠã¿ãŸãããã
ã³ã¡ã³ã