以下是MySQL常用的一些代码:
- 创建数据库:
- CREATE DATABASE database_name;
- 删除数据库:
- DROP DATABASE database_name;
- 创建表:
- CREATE TABLE table_name (
- column1 datatype,
- column2 datatype,
- column3 datatype,
- ...
- );
- 删除表:
- DROP TABLE table_name;
- 插入数据:
- INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
- 更新数据:
- UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
- 删除数据:
- DELETE FROM table_name WHERE condition;
- 查询数据:
- SELECT column1, column2, ... FROM table_name WHERE condition;
- 排序:
- SELECT column1, column2, ... FROM table_name ORDER BY column1 ASC/DESC;
- 分组:
- SELECT column1, COUNT(column2) FROM table_name GROUP BY column1;
- 连接:
- SELECT column1, column2, ... FROM table1 JOIN table2 ON table1.column = table2.column;
- 子查询:
- SELECT column1 FROM table1 WHERE column2 IN (SELECT column3 FROM table2 WHERE condition);
以上是MySQL常用的一些代码,可以根据实际需求进行使用和修改。