使用如下语句创建1个user数据表,CREATE TABLE `users` ( `Code` int(11) NOT NULL, `name` varchar(45) DEFAULT NULL, `sex` varchar(45) DEFAULT NULL, PRIMARY KEY (`Code`)) ENGINE=InnoDB DEFAULT CHARSET=utf8以下哪个SQL语句是正确的()
A. insert into users values('p001','张三','男');
B. create table 表名% select Code from users;
C. update users set Code='p002' where Code='p001';
D. select Code as '代号' from users;