pf6i22Ka

1CREATE DATABASE IF NOT EXISTS hc_star_fans DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2USE hc_star_fans;
3DROP TABLE IF EXISTS star_fans;
4CREATE TABLE star_fans (
5    uid mediumint(8) unsigned NOT NULL,
6    star_name varchar(255) NOT NULL DEFAULT '',
7    fans_phone varchar(255) NOT NULL DEFAULT '',
8    PRIMARY KEY (uid)
9) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
10
11INSERT INTO `star_fans` (`uid`, `star_name`, `fans_phone`) VALUES
12(173, '黃圩鎮', 4),
13(163, '黃圩鎮', 4),
14(1763, '黃圩鎮', 4),
15(1463, '黃圩鎮', 4),
16(146, '黃圩鎮', 4),
17(147631, '黃圩鎮', 4),
18(147632, '黃圩鎮', 4),
19(147633, '黃圩鎮', 4),
20(147634, '黃圩鎮', 4),
21(147635, '黃圩鎮', 4),
22(147636, '黃圩鎮', 4),
23(147637, '黃圩鎮', 4),
24(114763, '黃圩鎮', 4),
25(214763, '黃圩鎮', 4),
26(314763, '黃圩鎮', 4),
27(414763, '黃圩鎮', 4),
28(514763, '黃圩鎮', 4),
29(61476, '黃圩鎮', 4),
30(714763, '黃圩鎮', 4),
31(814763, '黃圩鎮', 4),
32(914763, '黃圩鎮', 4),
33(1014763, '黃圩鎮', 4),
34(1114763, '黃圩鎮', 4),
35(141763, '黃圩鎮', 4),
36(143763, '黃圩鎮', 4),
37(145763, '黃圩鎮', 4),
38(147563, '黃圩鎮', 4),
39(148763, '黃圩鎮', 4),
40(147063, '黃圩鎮', 4),
41(1471164, '萬盈鎮', 4);
42
43/*
44UPDATE `star_fans` SET `star_name`='bihicheng', `fans_phone`='18621067649' WHERE `uid` = 11111;
45
46DELETE FROM `star_fans` WHERE `uid` = 11111;
47
48SELECT `uid`, `star_name`, `fans_phone` FROM `star_fans`;
49
50#INSERT INTO `star_fans` (`star_name`, `fans_phone`) VALUES(11111, 'starname', 'fansphone');
51
52#ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
53
54#INSERT INTO `pre_common_district` (`id`, `name`, `level`, `upid`) VALUES (14763, '黃圩鎮', 4, 2103),(14764, '萬盈鎮', 4, 2104);
55
56ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
57
58ALTER TABLE logtest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
59
60ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
61
62ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];
63
64查看数据库编码：
65
66SHOW CREATE DATABASE db_name;
67
68查看表编码：
69
70SHOW CREATE TABLE tbl_name;
71
72查看字段编码：
73
74SHOW FULL COLUMNS FROM tbl_name;
75
76#insert into star_fans set `star_name`='2222', `fans_phone` = '1234561' ;
77*/