CREATE TABLE users(
id INT(11) NOT NULL AUTO_INCREMENT,
username VARCHAR(100),
PASSWORD VARCHAR(100),
realname VARCHAR(100),
address VARCHAR(100),
telPhone VARCHAR(100),
mobile VARCHAR(100),
email VARCHAR(100),
memo VARCHAR(100),
PRIMARY KEY (id)
)ENGINE=MYISAM DEFAULT CHARSET=utf8;
建表时在语句后面加上ENGINE=MYISAM DEFAULT CHARSET=utf8;就ok了