數(shù)據(jù)庫(kù)原理與應(yīng)用課程設(shè)計(jì)-文庫(kù)吧資料
2025-07-03 10:15本頁(yè)面
【正文】 39。insert into borrow_record(bookid,readerid,borrowdate)values(39。)update system_booksset isborrowed=0where bookid=39。,39。,39。)4添加已借書(shū)讀者的記錄，同時(shí)將在已借出的借閱標(biāo)記置0*/insert into borrow_record(bookid,readerid,borrowdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。3將已有圖書(shū)證的讀者加入system_readers表中*/insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。139。2000012139。1999022839。北京大學(xué)出版社39。蘇慶東39。239。探索宇宙奧秘39。56580002039。)。,39。,39。,39。,39。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。139。2001111539。2000100339。北京大學(xué)出版社39。李小剛39。539。微觀經(jīng)濟(jì)學(xué)39。1515465639。)。,39。,39。,39。,39。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。139。2002091539。2001020239。北京大學(xué)出版社39。趙文華39。339。古代埃及39。01511539。)。,39。,39。,39。,39。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。139。2004012139。2002062839。清華大學(xué)出版社39。吳偉民，嚴(yán)蔚敏39。639。數(shù)據(jù)結(jié)構(gòu)（C語(yǔ)言版）39。4545614141439。)。,39。,39。,39。,39。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。139。2004031439。2002040239。清華大學(xué)出版社39。譚浩強(qiáng)39。639。C程序設(shè)計(jì)39。1221512139。)。,39。,39。,39。,39。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。139。2003111539。2001010339。清華大學(xué)出版社39。王愛(ài)英39。639。計(jì)算機(jī)組成原理39。0012541515339。)。,39。,39。,39。,39。,39。,39。,39。)2將已有的圖書(shū)加入system_books表中(定義相同的作者出版社的書(shū)本編號(hào)不一樣)insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。,39。)insert into book_style(bookstyleno,bookstyle)values(39。,39。)insert into book_style(bookstyleno,bookstyle)values(39。,39。)insert into book_style(bookstyleno,bookstyle)values(39。,39。)insert into book_style(bookstyleno,bookstyle)values(39。,39。)insert into book_style(bookstyleno,bookstyle)values(39。,39。) insert into book_style(bookstyleno,bookstyle)values(39。,39。, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GO2書(shū)本類(lèi)別表建立create table book_style( bookstyleno varchar(30) primary key, bookstyle varchar(30))3創(chuàng)建書(shū)庫(kù)表create table system_books( bookid varchar(20) primary key, boo
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號(hào)-1