解决创建主键报错:Incorrect column specifier for column id问题

CREATE TABLE t_user(
	id INT PRIMARY KEY AUTO_INCREMENT,
    -- id VARCHAR(10) PRIMARY KEY AUTO_INCREMENT, -- 会报错，这样写的话
    -- 报错信息：Incorrect column specifier for column 'id'
	usernmae VARCHAR(10),
	pwd VARCHAR(32),
	sex VARCHAR(4),
	age INT,
	phone VARCHAR(18),
	email VARCHAR(32),
	idcard VARCHAR(32),
	addr VARCHAR(32)
);
DROP TABLE IF EXISTS t_user;

INSERT INTO t_user VALUES('sasax','张三','123456','男',29,'1515465','szxZ@as.com','1213231','北京路');

INSERT INTO t_user VALUES(DEFAULT,'张三','123456','男',29,'1515465','szxZ@as.com','1213231','北京路');

INSERT INTO t_user VALUES(NULL,'张三','123456','男',29,'1515465','szxZ@as.com','1213231','北京路');

INSERT INTO t_user VALUES('sas','张三','123456','男',29,'1515465','szxZ@as.com','1213231','北京路');