SQL常用语句--超实用!!!
数据库:
1.创建数据库
CREATE DATABASE example_db;
2.删除数据库
DROP DATABASE example_db;
表:
3.创建表
CREATE TABLE employees(
employee_id INT PRIMARY KEY,
name VARCHAR(100),
age INT,
department_id INT);
4.删除表
DROP TABLE employees;
列:
5.添加列
ALTER TABLE employees ADD email VARCHAR(255);
6.删除列
ALTER TABLE employees DROP COLUMN email;
7.修改列
ALTER TABLE employees MODIFY COLUMN name VARCHAR(255);
8.重命名列
ALTER TABLE employees RENAME COLUMN name TO fullname;
索引:
9.创建索引
CREATE INDEX idx_employee_name ON employees(name);
10.删除索引
DROP INDEX idx_employee_name ON employees(name);
视图:
11.创建视图
CREATE VIEW department_summary AS
SELETE department_id,count(*) AS
num_employees
FROM employees
GROUP BY department_id;
12.删除视图
DROP VIEW department_summary;
主键:
13.创建主键
ALTER TABLE employess ADD PRIMARY KEY (employee_id);
14.删除主键
ALTER TABLE employess DROP PRIMARY KEY;