diaobaaiqiqi的博客

一、准备数据库 DROP TABLE IF EXISTS `staff`; CREATE TABLE `staff` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `dept` var...

建表 插入数据 CREATE TABLE course ( id INT ( 20 ), sid INT ( 20 ), course VARCHAR ( 255 ), score INT ( 20 ) ); INSERT INTO `course` VALUES (1, 1, '语文', 43); INSERT INTO `course` VALUES (2, 1, '数学', 55); I...