MySQL数据库建表语句

**建立一个叫student的表**
CREATE TABLE`student`(
**id为int类型设置不能为空值**
`id` INT NOT NULL auto_increment primary key COMMENT'学生id',
`name`VARCHAR(16) NOT NULL COMMENT'学生姓名',
`sex` CHAR(1) DEFAULT'男' COMMENT'性别',
`age` INT COMMENT'年龄',
`birthday` datetime COMMENT'生日'

)DEFAULT CHARSET'utf8';
select * from student where id=1 order by id;