mysql中创建表
create table userInfo
(
userID int not null auto_increment primary key,
userName varchar(32) not null,
password varchar(32) not null default'0000',
state int not null default 0
)TYPE=MyISAM,default character set utf8;
Query OK, 0 rows affected (0.08 sec)
表结构显示
mysql> describe userInfo;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| userID | int(11) | NO | PRI | NULL | auto_increment |
| userName | varchar(32) | NO | | | |
| password | varchar(32) | NO | | 0000 | |
| state | int(11) | NO | | 0 | |
+----------+-------------+------+-----+---------+----------------+
mysql 中文乱码处理
my.ini中将default-character-set设置为utf8;[client]后面加default-character-set=utf8;
用show variables like '%char%' 查看字符编码