摘要:
public class Test10 { public static void main(String[] args) { System.out.println("-----------------------------商城库存清单----------------------------------"); System.out.printl... 阅读全文
摘要:
public class Test10 { public static void main(String[] args) { System.out.println("-----------------------------商城库存清单----------------------------------"); System.out.printl... 阅读全文
摘要:
USE h /*默认值*/ CREATE TABLE emp( id INT, ename VARCHAR(5), address VARCHAR(20) DEFAULT '山东淄博'(默认值) ) INSERT INTO emp(id,ename) VALUES(1,'张三'); INSERT INTO emp VALUES(... 阅读全文
摘要:
USE h CREATE TABLE zj1( protype_id INT PRIMARY KEY, protype_name VARCHAR(10) ) SELECT * FROM zj1; INSERT INTO zj1 VALUES(1,'家用电器'); INSERT INTO zj1 VALUES(2,'手机数码'); INSERT INTO zj... 阅读全文
摘要:
CREATE TABLE student( Sno VARCHAR(20) NOT NULL PRIMARY KEY, Sname VARCHAR(20) NOT NULL, Ssex VARCHAR(20) NOT NULL, Sbirthday DATETIME, Class VARCHAR(20) ) ... 阅读全文