-- 创建表时设置自增ID从负数开始
CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
) AUTO_INCREMENT = -2147483648;

-- 插入数据
INSERT INTO example (name) VALUES ('Newest Item');
INSERT INTO example (name) VALUES ('Older Item');

-- 查询时按ID降序排列
SELECT * FROM example ORDER BY id DESC;

-- 创建带时间戳的表
CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 插入数据
INSERT INTO example (name) VALUES ('Newest Item');
INSERT INTO example (name) VALUES ('Older Item');

-- 查询时按时间降序排列
SELECT * FROM example ORDER BY created_at DESC;

-- 创建视图按特定顺序显示
CREATE VIEW recent_first AS 
SELECT * FROM your_table ORDER BY id DESC;

-- 查询视图
SELECT * FROM recent_first;