数据库语句大全

以下是常见的数据库语句：

1. 创建数据库

CREATE DATABASE database_name;

2. 删除数据库

DROP DATABASE database_name;

3. 创建表

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... );

4. 删除表

DROP TABLE table_name;

5. 插入数据

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

6. 更新数据

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

7. 删除数据

DELETE FROM table_name WHERE condition;

8. 查询数据

SELECT column1, column2, ... FROM table_name WHERE condition;

9. 添加列

ALTER TABLE table_name ADD column_name datatype;

10. 修改列

ALTER TABLE table_name MODIFY column_name datatype;

11. 删除列

ALTER TABLE table_name DROP COLUMN column_name;

12. 创建索引

CREATE INDEX index_name ON table_name (column1, column2, ...);

13. 删除索引

DROP INDEX index_name ON table_name;

14. 创建视图

CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition;

15. 删除视图

DROP VIEW view_name;

16. 创建存储过程

CREATE PROCEDURE procedure_name AS BEGIN -- procedure code here END;

17. 删除存储过程

DROP PROCEDURE procedure_name;

18. 创建触发器

CREATE TRIGGER trigger_name ON table_name AFTER INSERT, UPDATE, DELETE AS BEGIN -- trigger code here END;

19. 删除触发器

DROP TRIGGER trigger_name ON table_name;

20. 创建用户

CREATE USER user_name;

21. 删除用户

DROP USER user_name;

以上是常见的数据库语句，不同的数据库系统可能有些许差异