数据库操作
-
创建数据库
CREATE DATABASE database_name;
-
删除数据库
DROP DATABASE database_name;
-
选择数据库
USE database_name;
2. 数据表操作
-
创建数据表
CREATE TABLE table_name (
column1 datatype constraints,
column2 datatype constraints,
column3 datatype constraints,
....
);
-
删除数据表
DROP TABLE table_name;
-
修改数据表
- 添加列
ALTER TABLE table_name ADD column_name datatype;
- 删除列
ALTER TABLE table_name DROP COLUMN column_name;
- 修改列的数据类型
ALTER TABLE table_name MODIFY COLUMN column_name new_datatype;
- 添加列
3. 数据操作
-
插入数据
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
-
查询数据
SELECT column1, column2, ...
FROM table_name
WHERE condition
ORDER BY column_name ASC|DESC;
-
更新数据
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
-
删除数据
DELETE FROM table_name WHERE condition;
4. 视图操作
-
创建视图
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
-
删除视图
DROP VIEW view_name;
5. 索引操作
-
创建索引
CREATE INDEX index_name ON table_name (column_name);
-
删除索引
DROP INDEX index_name ON table_name;
6. 权限操作
-
授予权限
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
-
撤销权限
REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'host';
7. 事务控制
-
开始事务
START TRANSACTION;
-
提交事务
COMMIT;
-
回滚事务
ROLLBACK;