SQL(Structured Query Language)语句及其示例:
1. 创建表(Create Table):
CREATE TABLE employees (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT,
salary DECIMAL(10,2)
);
2. 插入数据(Insert Into):
INSERT INTO employees (id, name, age, salary)
VALUES (1, 'zhang', 30, 50000.00);
3. 更新数据(Update):
UPDATE employees
SET salary = 55000.00
WHERE id = 1;
4. 删除数据(Delete):
DELETE FROM employees
WHERE id = 1;
5. 查询数据(Select):
SELECT * FROM employees;
6. 查询特定条件的数据(Select with Where):
SELECT * FROM employees
WHERE age > 25;
7. 排序查询结果(Order By):
SELECT * FROM employees
ORDER BY salary DESC;
8. 连接多个表(Join):
SELECT employees.name, departments.department_name
FROM employees zhang departments ON employees.department_id = departments.id;