摘要: -- 创造产品类型表 CREATE TABLE product_type( protype_id INT PRIMARY KEY AUTO_INCREMENT, protype_name VARCHAR(15) ) SELECT * FROM product_type; INSERT product_type(protype_name)V... 阅读全文
posted @ 2018-05-06 14:03 张锐0328 阅读(120) 评论(0) 推荐(0)
摘要: --创造学生情况表并添加数据CREATE TABLE student( Sno VARCHAR(20) PRIMARY KEY, Sname VARCHAR(20) NOT NULL, Ssex VARCHAR(20) NOT NULL, Sbirthday DATETIME, Class VARCHAR(20) ) DELETE FROM s... 阅读全文
posted @ 2018-05-06 14:02 张锐0328 阅读(105) 评论(0) 推荐(0)