【sql】sql必知必会_01

/* 2 Navicat Premium Data Transfer 3 4 Source Server : localhost_3306 5 Source Server Type : MySQL 6 Source Server Version : 80013 7 Source Host : localhost:3306 8 Source Schema : wucai 9 10 Target Server Type : MySQL 11 Target Server Version : 80013 12 File Encoding : 65001 13 14 Date: 03/07/2019 12:09:58 15 */ 16 17 SET NAMES utf8mb4; 18 SET FOREIGN_KEY_CHECKS = 0; 19 20 -- ---------------------------- 21 -- Table structure for heros 22 -- ---------------------------- 23 DROP TABLE IF EXISTS `heros`; 24 CREATE TABLE `heros` ( 25 `id` int(11) NOT NULL AUTO_INCREMENT, 26 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 27 `hp_max` float NULL DEFAULT NULL, 28 `hp_growth` float NULL DEFAULT NULL, 29 `hp_start` float NULL DEFAULT NULL, 30 `mp_max` float NULL DEFAULT NULL, 31 `mp_growth` float NULL DEFAULT NULL, 32 `mp_start` float NULL DEFAULT NULL, 33 `attack_max` float NULL DEFAULT NULL, 34 `attack_growth` float NULL DEFAULT NULL, 35 `attack_start` float NULL DEFAULT NULL, 36 `defense_max` float NULL DEFAULT NULL, 37 `defense_growth` float NULL DEFAULT NULL, 38 `defense_start` float NULL DEFAULT NULL, 39 `hp_5s_max` float NULL DEFAULT NULL, 40 `hp_5s_growth` float NULL DEFAULT NULL, 41 `hp_5s_start` float NULL DEFAULT NULL, 42 `mp_5s_max` float NULL DEFAULT NULL, 43 `mp_5s_growth` float NULL DEFAULT NULL, 44 `mp_5s_start` float NULL DEFAULT NULL, 45 `attack_speed_max` float NULL DEFAULT NULL, 46 `attack_range` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, 47 `role_main` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, 48 `role_assist` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, 49 `birthdate` date NULL DEFAULT NULL, 50 PRIMARY KEY (`id`) USING BTREE 51 ) ENGINE = InnoDB AUTO_INCREMENT = 10069 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; 52 53 -- ---------------------------- 54 -- Records of heros 55 -- ---------------------------- 56 INSERT INTO `heros` VALUES (10000, ‘夏侯惇‘, 7350, 288.8, 3307, 1746, 94, 430, 321, 11.57, 159, 397, 21.14, 101, 98, 3.357, 51, 37, 1.571, 15, 0, ‘近战‘, ‘坦克‘, ‘战士‘, ‘2016-07-19‘); 57 INSERT INTO `heros` VALUES (10001, ‘钟无艳‘, 7000, 275, 3150, 1760, 95, 430, 318, 11, 164, 409, 22.07, 100, 92, 3.143, 48, 37, 1.571, 15, 0, ‘近战‘, ‘战士‘, ‘坦克‘, NULL); 58 INSERT INTO `heros` VALUES (10002, ‘张飞‘, 8341, 329.4, 3450, 100, 0, 100, 301, 10.57, 153, 504, 27.07, 125, 115, 4.143, 57, 5, 0, 5, 0, ‘近战‘, ‘坦克‘, ‘辅助‘, NULL); 59 INSERT INTO `heros` VALUES (10003, ‘牛魔‘, 8476, 352.8, 3537, 1926, 104, 470, 273, 8.357, 156, 394, 20.36, 109, 117, 4.214, 58, 42, 1.786, 17, 0, ‘近战‘, ‘坦克‘, ‘辅助‘, ‘2015-11-24‘); 60 INSERT INTO `heros` VALUES (10004, ‘吕布‘, 7344, 270, 3564, 0, 0, 0, 343, 12.36, 170, 390, 20.79, 99, 97, 3.071, 54, 0, 0, 0, 0, ‘近战‘, ‘战士‘, ‘坦克‘, ‘2015-12-22‘); 61 INSERT INTO `heros` VALUES (10005, ‘亚瑟‘, 8050, 316.3, 3622, 0, 0, 0, 346, 13, 164, 400, 21.57, 98, 106, 3.643, 55, 0, 0, 0, 0, ‘近战‘, ‘战士‘, ‘坦克‘, NULL); 62 INSERT INTO `heros` VALUES (10006, ‘芈月‘, 6164, 281.5, 3105, 100, 0, 100, 289, 9.786, 152, 361, 19.5, 88, 77, 2.357, 44, 0, 0, 0, 0, ‘远程‘, ‘法师‘, ‘坦克‘, ‘2015-12-08‘); 63 INSERT INTO `heros` VALUES (10007, ‘程咬金‘, 8611, 369.6, 3437, 0, 0, 0, 316, 11.07, 161, 504, 27.07, 125, 119, 4.429, 57, 0, 0, 0, 0, ‘近战‘, ‘坦克‘, ‘战士‘, NULL); 64 INSERT INTO `heros` VALUES (10008, ‘廉颇‘, 9328, 412.1, 3558, 1708, 92, 420, 286, 8.786, 163, 514, 27.29, 132, 128, 4.929, 59, 36, 1.5, 15, 0, ‘近战‘, ‘坦克‘, NULL, NULL); 65 INSERT INTO `heros` VALUES (10009, ‘东皇太一‘, 7669, 319.1, 3201, 1926, 104, 470, 286, 8.786, 163, 360, 18.64, 99, 106, 3.786, 53, 42, 1.786, 17, 0, ‘近战‘, ‘坦克‘, NULL, ‘2017-03-30‘); 66 INSERT INTO `heros` VALUES (10010, ‘庄周‘, 8149, 345.6, 3311, 1694, 91, 420, 297, 9.071, 170, 497, 24.79, 150, 113, 4.143, 55, 36, 1.5, 15, 0, ‘近战‘, ‘辅助‘, ‘坦克‘, NULL); 67 INSERT INTO `heros` VALUES (10011, ‘太乙真人‘, 6835, 242.3, 3443, 1680, 90, 420, 284, 9.286, 154, 396, 21.57, 94, 86, 2.643, 49, 35, 1.429, 15, 0, ‘近战‘, ‘辅助‘, ‘坦克‘, ‘2016-11-24‘); 68 INSERT INTO `heros` VALUES (10012, ‘白起‘, 8638, 366.3, 3510, 1666, 89, 420, 288, 9.286, 158, 430, 22.14, 120, 119, 4.357, 58, 34, 1.429, 14, 0, ‘近战‘, ‘坦克‘, NULL, NULL); 69 INSERT INTO `heros` VALUES (10013, ‘雅典娜‘, 6264, 243, 2862, 1732, 93, 430, 327, 11.79, 162, 418, 22.29, 106, 83, 2.786, 44, 36, 1.5, 15, 0, ‘近战‘, ‘战士‘, ‘坦克‘, NULL); 70 INSERT INTO `heros` VALUES (10014, ‘刘邦‘, 8073, 336, 3369, 1940, 105, 470, 302, 10.29, 158, 504, 27.07, 125, 117, 4.214, 58, 42, 1.786, 17, 0, ‘近战‘, ‘坦克‘, ‘辅助‘, ‘2016-04-26‘); 71 INSERT INTO `heros` VALUES (10015, ‘刘禅‘, 8581, 372.6, 3364, 1694, 91, 420, 295, 8.357, 178, 459, 22.86, 139, 118, 4.429, 56, 36, 1.5, 15, 0, ‘近战‘, ‘坦克‘, NULL, NULL); 72 INSERT INTO `heros` VALUES (10016, ‘墨子‘, 7176, 292.4, 3083, 1722, 93, 420, 328, 10.5, 181, 475, 26.64, 102, 100, 3.5, 51, 37, 1.571, 15, 0, ‘近战‘, ‘法师‘, ‘坦克‘, NULL); 73 INSERT INTO `heros` VALUES (10017, ‘项羽‘, 8057, 380.1, 3535, 1694, 91, 420, 306, 10.64, 157, 494, 26.5, 123, 121, 4.5, 58, 36, 1.5, 15, 0, ‘近战‘, ‘坦克‘, NULL, NULL); 74 INSERT INTO `heros` VALUES (10018, ‘关羽‘, 7107, 270.4, 3322, 10, 0, 10, 343, 12.36, 170, 386, 20.36, 101, 94, 3.071, 51, 0, 0, 0, 0, ‘近战‘, ‘战士‘, ‘坦克‘, ‘2016-06-28‘); 75 INSERT INTO `heros` VALUES (10019, ‘后羿‘, 5986, 200.3, 3182, 1784, 96, 440, 396, 16.79, 161, 336, 17.86, 86, 71, 2.143, 41, 38, 1.571, 16, 0, ‘远程‘, ‘射手‘, NULL, NULL); 76 INSERT INTO `heros` VALUES (10020, ‘马可波罗‘, 5584, 181.6, 3041, 200, 0, 200, 362, 13.36, 175, 344, 18.07, 91, 75, 2.071, 46, 50, 0, 50, 0, ‘远程‘, ‘射手‘, NULL, ‘2016-08-23‘); 77 INSERT INTO `heros` VALUES (10021, ‘鲁班七号‘, 5989, 184.9, 3401, 1756, 94, 440, 400, 16.14, 174, 323, 16.79, 88, 69, 1.929, 42, 36, 1.5, 15, 0, ‘远程‘, ‘射手‘, NULL, NULL); 78 INSERT INTO `heros` VALUES (10022, ‘李元芳‘, 5725, 194.1, 3007, 1770, 95, 440, 396, 16.79, 161, 340, 18.07, 87, 66, 2.071, 37, 37, 1.571, 15, 0, ‘远程‘, ‘射手‘, NULL, ‘2016-04-12‘); 79 INSERT INTO `heros` VALUES (10023, ‘孙尚香‘, 6014, 198.5, 3235, 1756, 94, 440, 411, 17.07, 172, 346, 18.36, 89, 69, 2.071, 40, 36, 1.5, 15, 0, ‘远程‘, ‘射手‘, NULL, NULL); 80 INSERT INTO `heros` VALUES (10024, ‘黄忠‘, 5898, 194.6, 3173, 1784, 96, 440, 403, 16.5, 172, 319, 16.29, 91, 68, 2.071, 39, 38, 1.571, 16, 0, ‘远程‘, ‘射手‘, NULL, NULL); 81 INSERT INTO `heros` VALUES (10025, ‘狄仁杰‘, 5710, 176.3, 3242, 1770, 95, 440, 376, 14.79, 169, 338, 17.36, 95, 66, 1.857, 40, 37, 1.571, 15, 0, ‘远程‘, ‘射手‘, NULL, NULL); 82 INSERT INTO `heros` VALUES (10026, ‘虞姬‘, 5669, 192.3, 2977, 1770, 95, 440, 407, 17.29, 165, 329, 17.5, 84, 63, 1.929, 36, 38, 1.571, 16, 0, ‘远程‘, ‘射手‘, NULL, ‘2016-05-24‘); 83 INSERT INTO `heros` VALUES (10027, ‘成吉思汗‘, 5799, 198, 3027, 1742, 93, 440, 394,