5a9xPBjC

1CREATE DATABASE IF NOT EXISTS hc_star_fans DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2USE hc_star_fans;
3DROP TABLE IF EXISTS stars;
4CREATE TABLE stars (
5    uid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
6    star_name varchar(255) NOT NULL UNIQUE,
7    type enum('1'),
8    PRIMARY KEY (uid)
9) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
10
11DROP TABLE IF EXISTS fans;
12CREATE TABLE fans (
13    id tinyint(6) unsigned NOT NULL AUTO_INCREMENT,
14    star_id mediumint(8) unsigned NOT NULL,
15    fans_phone varchar(255) NOT NULL UNIQUE,
16    PRIMARY KEY (id)
17) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
18
19/*INSERT INTO `fans` (`star_id`, `fans_phone`) VALUES (123, '18621067646);*/
20INSERT INTO `stars` (`star_name`) VALUES
21('迈克-理查兹'),
22('文森特-孔帕尼'),
23('帕勃罗-萨巴莱塔'),
24('乔莱昂-莱斯科特'),    
25('詹姆斯-米尔纳'),
26('亚当-约翰逊'),
27('埃尔丁-哲科'),
28('亚历山大-科拉罗夫'),
29('斯蒂凡-萨维奇'),
30('塞尔吉奥-阿圭罗'),
31('加里斯-巴里'),
32('萨米尔-纳斯里'),
33('欧文-哈格里夫斯'),
34('大卫-席尔瓦'),
35('盖尔-克利希'),
36('乔-哈特'),
37('科洛-图雷'),
38('尼格尔-德容'),
39('亚亚-图雷'),
40('马里奥-巴洛特利');
41/*
42INSERT INTO `star_fans` (`uid`, `star_name`, `fans_phone`) VALUES
43(173, '黃圩鎮', 4),
44(163, '黃圩鎮', 4),
45(1763, '黃圩鎮', 4),
46(1463, '黃圩鎮', 4),
47(146, '黃圩鎮', 4),
48(147631, '黃圩鎮', 4),
49(147632, '黃圩鎮', 4),
50(147633, '黃圩鎮', 4),
51(147634, '黃圩鎮', 4),
52(147635, '黃圩鎮', 4),
53(147636, '黃圩鎮', 4),
54(147637, '黃圩鎮', 4),
55(114763, '黃圩鎮', 4),
56(214763, '黃圩鎮', 4),
57(314763, '黃圩鎮', 4),
58(414763, '黃圩鎮', 4),
59(514763, '黃圩鎮', 4),
60(61476, '黃圩鎮', 4),
61(714763, '黃圩鎮', 4),
62(814763, '黃圩鎮', 4),
63(914763, '黃圩鎮', 4),
64(1014763, '黃圩鎮', 4),
65(1114763, '黃圩鎮', 4),
66(141763, '黃圩鎮', 4),
67(143763, '黃圩鎮', 4),
68(145763, '黃圩鎮', 4),
69(147563, '黃圩鎮', 4),
70(148763, '黃圩鎮', 4),
71(147063, '黃圩鎮', 4),
72(1471164, '萬盈鎮', 4);
73
74UPDATE `star_fans` SET `star_name`='bihicheng', `fans_phone`='18621067649' WHERE `uid` = 11111;
75
76DELETE FROM `star_fans` WHERE `uid` = 11111;
77
78SELECT `uid`, `star_name`, `fans_phone` FROM `star_fans`;
79
80#INSERT INTO `star_fans` (`star_name`, `fans_phone`) VALUES(11111, 'starname', 'fansphone');
81
82#ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
83
84#INSERT INTO `pre_common_district` (`id`, `name`, `level`, `upid`) VALUES (14763, '黃圩鎮', 4, 2103),(14764, '萬盈鎮', 4, 2104);
85
86ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
87
88ALTER TABLE logtest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
89
90ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
91
92ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];
93
94查看数据库编码：
95
96SHOW CREATE DATABASE db_name;
97
98查看表编码：
99
100SHOW CREATE TABLE tbl_name;
101
102查看字段编码：
103
104SHOW FULL COLUMNS FROM tbl_name;
105
106INSERT INTO `stars` (`star_name`,`type`) VALUES ('test1', 1);
107
108#insert into star_fans set `star_name`='2222', `fans_phone` = '1234561' ;
109*/