create_table+insert_into

最新推荐文章于 2023-08-27 00:17:57 发布

nerdzws

最新推荐文章于 2023-08-27 00:17:57 发布

阅读量124

点赞数

本文链接：https://blog.csdn.net/wyzxzws/article/details/83524635

版权

[b]CREATE TABLE `student` (
`id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '编号',
`num` VARCHAR( 20 ) NOT NULL COMMENT '学号',
`name` VARCHAR( 20 ) NOT NULL COMMENT '姓名',
`gender` INT( 1 ) UNSIGNED NOT NULL COMMENT '性别',
`class` VARCHAR( 30 ) NOT NULL COMMENT '班级',
`score` INT( 4 ) NOT NULL COMMENT '分数'
) ENGINE = MYISAM ;
//-------------------------------------------------
INSERT INTO `yy`.`student` (
`id` ,
`num` ,
`name` ,
`gender` ,
`class` ,
`score`
)
VALUES (
NULL , '200811010121', '张文双', '1', '2008级1班', '91'
);[/b]