Mysql数据库的基本语法

Mysql数据库的基本语法包括：

1. 创建数据库：CREATE DATABASE database_name;

2. 选择数据库：USE database_name;

3. 创建表：CREATE TABLE table_name (column1 datatype, column2 datatype, column3 datatype,...);

4. 插入数据：INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...);

5. 查询数据：SELECT column1, column2,... FROM table_name WHERE condition;

6. 更新数据：UPDATE table_name SET column1 = value1, column2 = value2,... WHERE condition;

7. 删除数据：DELETE FROM table_name WHERE condition;

8. 删除表：DROP TABLE table_name;

9. 删除数据库：DROP DATABASE database_name;

10. 添加列：ALTER TABLE table_name ADD column_name datatype;

11. 修改列：ALTER TABLE table_name MODIFY column_name datatype;

12. 删除列：ALTER TABLE table_name DROP column_name;

13. 索引：CREATE INDEX index_name ON table_name (column_name);

14. 外键：ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES other_table (other_column);