使用如下语句创建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;