SQL基础（一）

SQL基础语法：

-- 创建数据库
CREATE DATABASE database_name;

-- 使用数据库
USE database_name;

-- 创建表
CREATE TABLE table_name (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT,
    email VARCHAR(100)
);

-- 插入数据
INSERT INTO table_name (id, name, age, email)
VALUES (1, 'Alice', 30, 'alice@example.com');

-- 查询数据
SELECT * FROM table_name;

-- 带条件查询
SELECT * FROM table_name WHERE age > 25;

-- 更新数据
UPDATE table_name
SET email = 'alice_new@example.com'
WHERE id = 1;

-- 删除数据
DELETE FROM table_name WHERE id = 1;

-- 添加列
ALTER TABLE table_name ADD COLUMN address VARCHAR(255);

-- 删除列
ALTER TABLE table_name DROP COLUMN address;

-- 创建索引
CREATE INDEX idx_name ON table_name (name);

-- 连接查询
SELECT a.name, b.email
FROM table_name a
JOIN another_table b ON a.id = b.id;

-- 分组查询
SELECT age, COUNT(*) AS count
FROM table_name
GROUP BY age;

-- 排序
SELECT * FROM table_name ORDER BY age DESC;
SELECT * FROM table_name ORDER BY age ASC;

如上。