【课堂】课堂插入

– 插入数据到 equipment 表
INSERT INTO w_equipment (id, NAME, equip_type, equip_level, career, durable, attack, defense, remark)
VALUES
(‘j00001’, ‘九曜戒指’, ‘戒指’, 40, ‘通用’, 36, 11, 7, ‘0 0:0:73’),
(‘j00002’, ‘化魔冥戒’, ‘戒指’, 39, ‘幽冥刺客’, 33, 13, 5, ‘0 0:2:42’),
(‘j00003’, ‘银魔手链’, ‘戒指’, 52, ‘通用’, 50, 16, 14, ‘0 0:5:0’),
(‘j00004’, ‘虚·阎罗陨戒’, ‘戒指’, 60, ‘通用’, 47, 15, 11, ‘0 0:10:0’),
(‘j00005’, ‘灵阳戒指’, ‘戒指’, 30, ‘通用’, 26, 17, 14, ‘0 0:0:85’),
(‘j00006’, ‘凤羽戒指’, ‘戒指’, 50, ‘通用’, 39, 28, 22, ‘0 0:6:67’),
(‘j00007’, ‘凝云戒指’, ‘戒指’, 50, ‘通用’, 39, 7, 5, ‘0 0:4:77’),
(‘j00008’, ‘烈炎戒指’, ‘戒指’, 30, ‘通用’, 26, 8, 6, ‘0 0:2:42’),
(‘j00009’, ‘魔蛟戒指’, ‘戒指’, 35, ‘通用’, 29, 19, 16, ‘0 0:5:33’),
(‘j00010’, ‘彩灵戒指’, ‘戒指’, 35, ‘通用’, 29, 19, 16, ‘0 0:5:33’),
(‘j00011’, ‘霜皇戒指’, ‘戒指’, 40, ‘通用’, 33, 23, 18, ‘0 0:5:33’),
(‘j00012’, ‘龙鳞戒指’, ‘戒指’, 45, ‘通用’, 36, 25, 19, ‘0 0:6:67’),
(‘j00013’, ‘霜皇戒指’, ‘戒指’, 40, ‘通用’, 33, 23, 18, ‘0 0:5:33’),
(‘j00014’, ‘幻炀戒指’, ‘戒指’, 55, ‘通用’, 44, 15, 11, ‘0 0:5:72’),
(‘k00001’, ‘魔岩冥服’, ‘铠甲’, 5, ‘幽冥刺客’, 27, 0, 15, ‘0 0:0:9’),
(‘k00002’, ‘敏捷冥服’, ‘铠甲’, 30, ‘幽冥刺客’, 119, 0, 19, ‘0 0:2:60’),
(‘k00003’, ‘七煞星之冥服’, ‘铠甲’, 30, ‘幽冥刺客’, 140, 0, 36, ‘0 0:2:67’),
(‘k00004’, ‘幽冥的召唤冥服’, ‘铠甲’, 60, ‘幽冥刺客’, 197, 0, 105, ‘0 0:35:29’),
(‘k00005’, ‘轻便衣甲’, ‘铠甲’, 20, ‘翎羽弓魂’, 81, 0, 9, ‘0 0:0:85’),
(‘k00006’, ‘枯木衣甲’, ‘铠甲’, 10, ‘翎羽弓魂’, 54, 0, 9, ‘0 0:0:18’),
(‘k00007’, ‘黑暗涌动衣甲’, ‘铠甲’, 30, ‘翎羽弓魂’, 151, 0, 51, ‘0 0:2:71’),
(‘k00008’, ‘龙王的颤抖衣甲’, ‘铠甲’, 40, ‘翎羽弓魂’, 189, 0, 68, ‘0 0:5:35’),
(‘k00009’, ‘轻皮冥面’, ‘铠甲’, 5, ‘幽冥刺客’, 22, 0, 3, ‘0 0:0:7’),
(‘k00010’, ‘古朴战甲’, ‘铠甲’, 40, ‘隐龙战士’, 135, 0, 29, ‘0 0:5:5’),
(‘k00011’, ‘鲲鹏·九霄的徘徊战甲’, ‘铠甲’, 40, ‘隐龙战士’, 221, 0, 106, ‘0 0:6:68’),
(‘k00012’, ‘玄炎·灵犀的守护腰带’, ‘铠甲’, 48, ‘隐龙战士’, 106, 0, 56, ‘0 0:6:68’),
(‘k00013’, ‘薄雾法袍’, ‘铠甲’, 10, ‘济世医师’, 36, 0, 8, ‘0 0:0:18’),
(‘k00014’, ‘溟·四海之回响法带’, ‘铠甲’, 48, ‘济世医师’, 60, 0, 21, ‘0 0:5:18’),
(‘s00001’, ‘圣乾手镯’, ‘手镯’, 60, ‘通用’, 47, 13, 8, ‘0 0:0:37’),
(‘s00002’, ‘天罡手镯’, ‘手镯’, 25, ‘通用’, 21, 6, 4, ‘0 0:0:73’),
(‘s00003’, ‘冥灵手镯’, ‘手镯’, 25, ‘通用’, 21, 6, 4, ‘0 0:0:73’),
(‘s00004’, ‘魔蛟手镯’, ‘手镯’, 35, ‘通用’, 29, 9, 6, ‘0 0:2:42’),
(‘s00005’, ‘彩灵手镯’, ‘手镯’, 35, ‘通用’, 29, 9, 6, ‘0 0:2:42’),
(‘s00006’, ‘八卦护手’, ‘手镯’, 38, ‘通用’, 40, 0, 14, ‘0 0:2:8’),
(‘t00001’, ‘两仪道冠’, ‘头盔’, 29, ‘通用’, 64, 11, 21, ‘0 0:2:8’),
(‘t00002’, ‘毁灭头饰’, ‘头盔’, 45, ‘通用’, 103, 22, 45, ‘0 0:9:86’),
(‘w00001’, ‘梦璃灵刀’, ‘武器’, 30, ‘隐龙战士’, 88, 135, 0, ‘0 0:3:17’),
(‘w00002’, ‘梦璃灵匕’, ‘武器’, 30, ‘幽冥刺客’, 88, 113, 0, ‘0 0:3:17’),
(‘w00003’, ‘梦璃灵剑’, ‘武器’, 30, ‘玄灵天师’, 88, 135, 0, ‘0 0:3:17’),
(‘w00004’, ‘梦璃灵杖’, ‘武器’, 30, ‘济世医师’, 40, 77, 0, ‘0 0:3:17’),
(‘w00005’, ‘梦璃灵弓’, ‘武器’, 30, ‘翎羽弓魂’, 88, 158, 0, ‘0 0:3:17’),
(‘w00006’, ‘星宿之离玄剑’, ‘武器’, 5, ‘玄灵天师’, 19, 11, 0, ‘0 0:0:10’),
(‘w00007’, ‘星宿之御藏剑’, ‘武器’, 10, ‘玄灵天师’, 31, 17, 0, ‘0 0:0:23’),
(‘w00008’, ‘星宿之断魂’, ‘武器’, 20, ‘玄灵天师’, 46, 31, 0, ‘0 0:1:7’),
(‘w00009’, ‘星宿之煞元’, ‘武器’, 50, ‘玄灵天师’, 103, 82, 0, ‘0 0:15:77’),
(‘w00010’, ‘蝉翼利刃’, ‘武器’, 20, ‘幽冥刺客’, 60, 55, 0, ‘0 0:1:7’),
(‘w00011’, ‘寻欢之匕’, ‘武器’, 30, ‘幽冥刺客’, 96, 148, 0, ‘0 0:3:17’),
(‘w00012’, ‘修罗·黄泉的凝视’, ‘武器’, 40, ‘幽冥刺客’, 132, 307, 0, ‘0 0:6:32’),
(‘w00013’, ‘雷公的毁灭之刺’, ‘武器’, 50, ‘幽冥刺客’, 156, 272, 0, ‘0 0:15:77’),
(‘w00014’, ‘烛龙·死亡的翱翔’, ‘武器’, 50, ‘幽冥刺客’, 168, 428, 0, ‘0 0:15:77’),
(‘w00015’, ‘地藏·地狱的抚摸’, ‘武器’, 60, ‘幽冥刺客’, 208, 576, 0, ‘0 0:36:70’),
(‘w00016’, ‘万语的勿念之刃’, ‘武器’, 65, ‘幽冥刺客’, 193, 434, 0, ‘0 0:34:95’),
(‘w00017’, ‘青铜剑’, ‘武器’, 50, ‘玄灵天师’, 93, 58, 0, ‘0 0:15:77’),
(‘w00018’, ‘暗红桃木剑’, ‘武器’, 5, ‘玄灵天师’, 19, 11, 0, ‘0 0:0:10’),
(‘w00019’, ‘寰宇’, ‘武器’, 10, ‘玄灵天师’, 40, 43, 0, ‘0 0:0:23’),
(‘w00020’, ‘噬魔雷光剑’, ‘武器’, 30, ‘玄灵天师’, 74, 83, 0, ‘0 0:3:17’),
(‘w00021’, ‘诛仙·通天之法能’, ‘武器’, 40, ‘玄灵天师’, 102, 173, 0, ‘0 0:6:32’),
(‘w00022’, ‘极阳·祝融的眼泪’, ‘武器’, 50, ‘玄灵天师’, 131, 242, 0, ‘0 0:15:77’),
(‘w00023’, ‘古朴长枪’, ‘武器’, 1, ‘隐龙战士’, 15, 21, 0, ‘0 0:0:2’),
(‘w00024’, ‘青云’, ‘武器’, 5, ‘隐龙战士’, 29, 67, 0, ‘0 0:0:10’),
(‘w00025’, ‘烈火碎尖枪’, ‘武器’, 20, ‘隐龙战士’, 64, 185, 0, ‘0 0:1:7’),
(‘w00026’, ‘修罗·邪神撕裂者’, ‘武器’, 40, ‘隐龙战士’, 119, 575, 0, ‘0 0:6:32’),
(‘w00027’, ‘极阳·金乌的威慑’, ‘武器’, 50, ‘隐龙战士’, 151, 806, 0, ‘0 0:15:77’),
(‘w00028’, ‘桐木枪’, ‘武器’, 60, ‘隐龙战士’, 135, 337, 0, ‘0 0:34:28’),
(‘w00029’, ‘极光·璇玑的坚韧’, ‘武器’, 60, ‘隐龙战士’, 139, 1080, 0, ‘0 0:36:70’),
(‘w00030’, ‘风暴之五虎忠魂’, ‘武器’, 60, ‘隐龙战士’, 135, 337, 0, ‘0 0:34:28’),
(‘y00001’, ‘毁灭护腰’, ‘腰带’, 45, ‘通用’, 52, 12, 22, ‘0 0:4:96’),
(‘y00002’, ‘炽热·火凤之羽腰带’, ‘腰带’, 45, ‘通用’, 50, 22, 40, ‘0 0:2:17’);

INSERT INTO w_characters (id, NAME, health_val, mana_val, career_type, binding_wallet, binding_gold, binding_sex, health_max, mana_max, level_curr)
VALUES
(‘g000001’, ‘ヤ瞳殇ゞ’, 19, 15, ‘隐龙战士’, NULL, ‘20:0:0’, ‘男’, 19, 15, 1),
(‘g000002’, ‘是柠檬就别羡慕西瓜的甜’, 200, 81, ‘翎羽弓魂’, NULL, ‘30:30:0’, ‘女’, 200, 81, 20),
(‘g000003’, ‘帅得掉渣了’, 419, 116, ‘翎羽弓魂’, NULL, ‘5:105:0’, ‘男’, 419, 116, 30),
(‘g000004’, ‘张三丰’, 77, 277, ‘隐龙战士’, NULL, ‘100:10:800’, ‘男’, 77, 277, 20),
(‘g000005’, ‘难逃温柔乡’, 381, 453, ‘幽冥刺客’, NULL, ‘200:0:999:05’, ‘男’, 381, 453, 40),
(‘g000006’, ‘雨寒’, 77, 277, ‘玄灵天师’, NULL, ‘8:10:10’, ‘女’, 77, 277, 20),
(‘g000007’, ‘有吃有喝有人爱’, 656, 845, ‘幽冥刺客’, NULL, ‘1:500:0’, ‘男’, 656, 845, 55),
(‘g000008’, ‘狂斩天下’, 764, 1003, ‘翎羽弓魂’, NULL, ‘6:50:50’, ‘男’, 764, 1003, 60),
(‘g000009’, ‘寒月舞清影’, 271, 1333, ‘玄灵天师’, NULL, ‘9:105:900’, ‘女’, 271, 1333, 50),
(‘g000010’, ‘冷曦ゝ’, 271, 1333, ‘玄灵天师’, NULL, ‘1:85:10’, ‘女’, 271, 1333, 50);

INSERT INTO w_chts_equip (cid, eid, is_binding, binding_address, binding_date, equip_type)
VALUES
(‘g000002’, ‘t00001’, ‘1’, ‘五指山’, ‘2020-01-01 00:00:00’, ‘头盔’),
(‘g000007’, ‘j00011’, ‘1’, ‘宝象国’, ‘2020-08-11 12:31:05’, ‘戒指’),
(‘g000009’, ‘j00012’, ‘0’, ‘五指山’, ‘2020-03-10 10:22:09’, ‘戒指’),
(‘g000008’, ‘k00008’, ‘1’, ‘宝象国’, ‘2020-05-09 11:30:15’, ‘铠甲’),
(‘g000003’, ‘w00005’, ‘1’, ‘宝象国’, ‘2020-01-10 09:01:20’, ‘武器’),
(‘g000008’, ‘y00002’, ‘1’, ‘五指山’, ‘2020-02-06 01:10:05’, ‘腰带’),
(‘g000009’, ‘w00022’, ‘0’, ‘宝象国’, ‘2020-06-11 05:01:25’, ‘武器’),
(‘g000007’, ‘k00002’, ‘1’, ‘宝象国’, ‘2020-08-10 09:01:15’, ‘铠甲’),
(‘g000003’, ‘k00007’, ‘1’, ‘天宫’, ‘2020-08-11 12:31:35’, ‘铠甲’),
(‘g000008’, ‘t00002’, ‘1’, ‘宝象国’, ‘2020-02-21 12:31:56’, ‘头盔’),
(‘g000004’, ‘w00025’, ‘0’, ‘火焰山’, ‘2020-10-22 13:20:41’, ‘武器’),
(‘g000008’, ‘j00003’, ‘1’, ‘宝象国’, ‘2020-02-01 16:35:22’, ‘戒指’),
(‘g000005’, ‘w00011’, ‘1’, ‘宝象国’, ‘2020-05-07 18:37:05’, ‘武器’),
(‘g000005’, ‘k00003’, ‘1’, ‘乌鸡国’, ‘2020-09-17 19:49:18’, ‘铠甲’),
(‘g000007’, ‘j00003’, ‘0’, ‘宝象国’, ‘2020-11-26 22:21:25’, ‘戒指’),
(‘g000006’, ‘w00008’, ‘0’, ‘乌鸡国’, ‘2020-12-11 12:31:05’, ‘武器’),
(‘g000007’, ‘w00012’, ‘1’, ‘宝象国’, ‘2020-09-13 12:31:05’, ‘武器’),
(‘g000008’, ‘s00001’, ‘1’, ‘天宫’, ‘2020-02-10 12:31:05’, ‘手镯’),
(‘g000009’, ‘j00013’, ‘0’, ‘宝象国’, ‘2020-01-13 12:31:05’, ‘戒指’),
(‘g000003’, ‘s00002’, ‘1’, ‘宝象国’, ‘2020-03-21 12:31:05’, ‘手镯’),
(‘g000005’, ‘s00002’, ‘1’, ‘火焰山’, ‘2020-05-01 12:31:05’, ‘手镯’),
(‘g000009’, ‘s00002’, ‘1’, ‘宝象国’, ‘2020-09-11 12:31:05’, ‘手镯’),
(‘g000009’, ‘s00006’, ‘1’, ‘天宫’, ‘2020-09-11 12:31:05’, ‘手镯’);