【sql】sql必知必会_01
时间：2021-07-01 10:21:17
帮助过：19人阅读
/*
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,
