我刚刚学,只有插入 CREATE TABLE BOOK( Primary_Author VARCHAR(60) NOT NULL, Title VARCHAR(50) NOT NULL, ISBN VARCHAR(20) NOT NULL, PublisherID VARCHAR(20) NOT NULL, Edition VARCHAR(30) NOT NULL, Date_Publication DATE NOT NULL, Price DECIMAL(4,2) NOT NULL, Book_Description VARCHAR(500), PRIMARY KEY(ISBN), FOREIGN KEY(PublisherID) REFERENCES PUBLISHER(PublisherID) ); CREATE TABLE PUBLISHER( PublisherID VARCHAR(20) NOT NULL, Name VARCHAR(20) NOT NULL, Address VARCHAR(20) NOT NULL, PRIMARY KEY(PublisherID), FOREIGN KEY(PublisherID)REFERENCES BOOK(PublisherID) );INSERT INTO BOOK VALUES('Begg', 'DATABASE SYSTEM', '7-5053-9418-5', '001', 'FIRST', '2006-8-21', '79.00', 'For students who are studying the software');INSERT INTO BOOK VALUES('Galvin', 'OPERATING STSTEM CONCEPTS', '897-7-013301-1', '004', 'SECOND', '2003-04-03', '55.00', 'Discuss the basic concepts and methods in operating system.'); INSERT INTO BOOK VALUES('Kundera', 'L.insoutenable', '7-5327-3107-3', '023', 'ELEVEN', '2005-07-01', '23.00', 'About philosophy .'); INSERT INTO BOOK VALUES('Goethe', 'Faust', '7-02-003962-6', '023', 'THREE', '2003-04-03', '18.00', 'The famous work of Goethe.');INSERT INTO PUBLISHER VALUES('001','Electronic INSERT INTO PUBLISHERIndustry','BEI JING');INSERT INTO PUBLISHER VALUES('004','Hither Education Press','BEI JING');INSERT INTO PUBLISHER VALUES('023',' People's Iterature Press','BEI JING');INSERT INTO PUBLISHER VALUES('055','ShangHai Press','SHANG HAI');
CREATE TABLE PUBLISHER( PublisherID VARCHAR(20) NOT NULL, Name VARCHAR(20) NOT NULL, Address VARCHAR(20) NOT NULL, PRIMARY KEY(PublisherID), FOREIGN KEY(PublisherID)REFERENCES BOOK(PublisherID) ); 把这句删除了试试[align=center]====思想重于技巧==== [/align]
[/align]
CREATE TABLE BOOK( Primary_Author VARCHAR(60) NOT NULL,
Title VARCHAR(50) NOT NULL,
ISBN VARCHAR(20) NOT NULL,
PublisherID VARCHAR(20) NOT NULL,
Edition VARCHAR(30) NOT NULL,
Date_Publication DATE NOT NULL,
Price DECIMAL(4,2) NOT NULL,
Book_Description VARCHAR(500),
PRIMARY KEY(ISBN),
FOREIGN KEY(PublisherID) REFERENCES PUBLISHER(PublisherID)
);
CREATE TABLE PUBLISHER( PublisherID VARCHAR(20) NOT NULL,
Name VARCHAR(20) NOT NULL,
Address VARCHAR(20) NOT NULL,
PRIMARY KEY(PublisherID),
FOREIGN KEY(PublisherID)REFERENCES BOOK(PublisherID)
);INSERT INTO BOOK
VALUES('Begg', 'DATABASE SYSTEM', '7-5053-9418-5', '001', 'FIRST', '2006-8-21', '79.00', 'For students who are studying the software');INSERT INTO BOOK
VALUES('Galvin', 'OPERATING STSTEM CONCEPTS', '897-7-013301-1', '004', 'SECOND', '2003-04-03', '55.00', 'Discuss the basic concepts and methods in operating system.');
INSERT INTO BOOK
VALUES('Kundera', 'L.insoutenable', '7-5327-3107-3', '023', 'ELEVEN', '2005-07-01', '23.00', 'About philosophy .');
INSERT INTO BOOK
VALUES('Goethe', 'Faust', '7-02-003962-6', '023', 'THREE', '2003-04-03', '18.00', 'The famous work of Goethe.');INSERT INTO PUBLISHER
VALUES('001','Electronic INSERT INTO PUBLISHERIndustry','BEI JING');INSERT INTO PUBLISHER
VALUES('004','Hither Education Press','BEI JING');INSERT INTO PUBLISHER
VALUES('023',' People's Iterature Press','BEI JING');INSERT INTO PUBLISHER
VALUES('055','ShangHai Press','SHANG HAI');
Name VARCHAR(20) NOT NULL,
Address VARCHAR(20) NOT NULL,
PRIMARY KEY(PublisherID),
FOREIGN KEY(PublisherID)REFERENCES BOOK(PublisherID));
把这句删除了试试[align=center]==== 思想重于技巧 ====
[/align]