More than 5 years have passed since last update.

SQLコマンド一覧

Last updated at 2016-01-24Posted at 2016-01-24

よく使うSQLコマンドの一覧を作成

【使用するDBの選択】
USE DB名前;
【table内のFieldを調べる】
DESCRIBE table名前;

例　mysql> DESCRIBE my_items;
+------------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| items_name | text | YES | | NULL | |
| price | int(11) | YES | | NULL | |
+------------+---------+------+-----+---------+-------+

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up