使用AI生成DDL/DML/DQL语句

问题：

请帮我生成一个用户表，先给出建表语句，再给插入语句，最后给查询语句，豆包返回对应的create开头，inselect开头select开头的SQL语句：

DDL

–sq1
– 创建王者荣耀英雄榜单表
CREATE TABLE IF NOT EXISTS honor_of_kings_hero_ranking (
id INT AUTO_INCREMENT PRIMARY KEY COMMENT ‘主键ID，自增’,
hero_name VARCHAR(50) NOT NULL COMMENT ‘英雄名称’,
hero_type VARCHAR(30) NOT NULL COMMENT ‘英雄类型（坦克/法师/射手/刺客/辅助/战士）’,
usage_rate DECIMAL(5,2) NOT NULL COMMENT ‘使用率（百分比，如15.68）’,
kill_rate DECIMAL(5,2) NOT NULL COMMENT ‘击杀率（百分比，如8.25）’,
death_rate DECIMAL(5,2) NOT NULL COMMENT ‘死亡率（百分比，如6.12）’,
assist_rate DECIMAL(5,2) NOT NULL COMMENT ‘助攻率（百分比，如18.90）’,
win_rate DECIMAL(5,2) NOT NULL COMMENT ‘胜率（百分比，如51.23）’,
update_date DATE NOT NULL COMMENT ‘数据更新日期’,
is_seasonal TINYINT(1) DEFAULT 1 COMMENT ‘是否为当前赛季数据（1是，0否）’,
– 添加索引提升查询效率
INDEX idx_hero_name (hero_name),
INDEX idx_hero_type (hero_type),
INDEX idx_win_rate (win_rate),
INDEX idx_usage_rate (usage_rate)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=‘王者荣耀英雄使用率、击杀率等榜单表’;

DML

– 插入示例数据
INSERT INTO honor_of_kings_hero_ranking (
hero_name, hero_type, usage_rate, kill_rate, death_rate, assist_rate, win_rate, update_date, is_seasonal
) VALUES
(‘鲁班七号’, ‘射手’, 28.56, 9.87, 7.65, 12.34, 48.90, ‘2026-03-04’, 1),
(‘妲己’, ‘法师’, 35.78, 8.92, 6.88, 10.56, 50.12, ‘2026-03-04’, 1),
(‘铠’, ‘战士’, 22.34, 10.12, 5.98, 15.67, 52.34, ‘2026-03-04’, 1),
(‘牛魔’, ‘辅助’, 18.90, 2.34, 7.89, 25.67, 53.45, ‘2026-03-04’, 1),
(‘兰陵王’, ‘刺客’, 15.67, 12.34, 4.56, 8.90, 49.87, ‘2026-03-04’, 1),
(‘程咬金’, ‘坦克’, 12.45, 5.67, 8.90, 11.23, 51.67, ‘2026-03-04’, 1),
(‘诸葛亮’, ‘法师’, 20.12, 9.87, 6.78, 14.56, 49.23, ‘2026-03-04’, 1),
(‘后羿’, ‘射手’, 30.89, 8.76, 8.12, 13.45, 47.89, ‘2026-03-04’, 1);

DQL

– 查询所有英雄的完整数据
SELECT * FROM honor_of_kings_hero_ranking;

– 查询指定英雄（如鲁班七号）的详细数据
SELECT hero_name, usage_rate, kill_rate, win_rate
FROM honor_of_kings_hero_ranking
WHERE hero_name = ‘鲁班七号’;

– 查询当前赛季的所有英雄数据
SELECT hero_name, hero_type, win_rate
FROM honor_of_kings_hero_ranking
WHERE is_seasonal = 1;

语句类别说明