CREATE TABLE IF NOT EXISTS student(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '姓名',
`age` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '年齡',
`sex` TINYINT UNSIGNED NOT NULL DEFAULT 10 COMMENT '性別',
`created_at` INT NOT NULL DEFAULT 0 COMMENT '新增時(shí)間',
`updated_at` INT NOT NULL DEFAULT 0 COMMENT '修改時(shí)間'
)ENGINE=INNODB DEFAULT CHARSET = UTF8 AUTO_INCREMENT=1001 COMMENT='學(xué)生表';
