SQL插入查询性能

提升SQL插入查询性能的关键方法

sql
-- 创建索引
CREATE INDEX idx_username ON users(username);
-- 查询
SELECT * FROM users WHERE username = 'john_doe';
-- 插入数据
INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');

sql
-- 单条插入
INSERT INTO orders (order_id, product, quantity) VALUES (1, 'Laptop', 5);
-- 批量插入
INSERT INTO orders (order_id, product, quantity)
VALUES
    (2, 'Desktop', 3),
    (3, 'Monitor', 2),
    (4, 'Keyboard', 10);

sql
-- 使用整数型ID
CREATE TABLE products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(255)
);
-- 插入数据
INSERT INTO products (product_id, product_name) VALUES (1, 'Laptop');

sql
-- 创建分区表
CREATE TABLE orders (
    order_id INT,
    order_date DATE
) PARTITION BY RANGE (YEAR(order_date)) (
    PARTITION p0 VALUES LESS THAN (1990),
    PARTITION p1 VALUES LESS THAN (2000),
    PARTITION p2 VALUES LESS THAN (2010),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);