mysql有哪些是指定范围的

-- 查询年龄在20到30岁之间的用户
SELECT * FROM users WHERE age BETWEEN 20 AND 30;

-- 查询价格在100到200之间的商品
SELECT * FROM products WHERE price BETWEEN 100 AND 200;

-- 查询在2023年1月1日到2023年12月31日之间的订单
SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

-- 创建索引
CREATE INDEX idx_age ON users(age);

-- 创建分区表
CREATE TABLE orders (
    order_id INT,
    order_date DATE,
    amount DECIMAL(10, 2)
) PARTITION BY RANGE (YEAR(order_date)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

-- 使用事务
START TRANSACTION;
SELECT * FROM users WHERE age BETWEEN 20 AND 30 FOR UPDATE;
UPDATE users SET status = 'active' WHERE age BETWEEN 20 AND 30;
COMMIT;