mysql数据库指令图解

+--------------------------+
|       MySQL指令图解       |
+--------------------------+
|    创建数据库：CREATE DATABASE database_name;    |
|    删除数据库：DROP DATABASE database_name;      |
|    使用数据库：USE database_name;                |
|                                                |
|    创建表格：CREATE TABLE table_name (            |
|                  column1 datatype,               |
|                  column2 datatype,               |
|                  ...                            |
|                  columnN datatype                |
|                );                               |
|                                                |
|    删除表格：DROP TABLE table_name;              |
|                                                |
|    插入数据：INSERT INTO table_name (column1,      |
|                                  column2,      |
|                                  ...,         |
|                                  columnN)     |
|               VALUES (value1, value2, ..., valueN); |
|                                                |
|    查询数据：SELECT column1, column2, ..., columnN |
|               FROM table_name;                   |
|                                                |
|    更新数据：UPDATE table_name                     |
|               SET column1 = value1,              |
|                   column2 = value2,              |
|                   ...                            |
|               WHERE condition;                   |
|                                                |
|    删除数据：DELETE FROM table_name                |
|               WHERE condition;                   |
|                                                |
|    查询条件：WHERE、ORDER BY、GROUP BY、HAVING、   |
|              LIMIT等等                          |
+------------------------------------------------+