数据库课程设计例子(3)

来源：网络收集时间：2026-09-09

导读： insert into system_readers(readerid,readername,readersex,readertype,regdate) values('X05620202','潘虹','女','学生','2005-09-30 13:24:54.473') insert into system_readers(readerid,readername,readersex,

insert into system_readers(readerid,readername,readersex,readertype,regdate) values('X05620202','潘虹','女','学生','2005-09-30 13:24:54.473')

insert into system_readers(readerid,readername,readersex,readertype,regdate) values('008415','蒋伟','男','教师','2004-04-30 09:24:54.478')

insert into system_readers(readerid,readername,readersex,readertype,regdate) values('001456','李叶风','女','教师','2004-04-30 09:24:54.478')

3.2.4添加已借书读者的记录，同时将在已借出的借阅标记置0*/ insert into borrow_record(bookid,readerid,borrowdate)

values('00125415152','X05620202','2007-09-27 11:24:54.123') update system_books set isborrowed=0

where bookid='00125415152'

insert into borrow_record(bookid,readerid,borrowdate)

values('00125415153','X05620206','2007-12-27 08:26:51.452') update system_books set isborrowed=0

where bookid='00125415153' and isborrowed='1'

insert into borrow_record(bookid,readerid,borrowdate) values('5455515','X05620207','2007-12-27 08:26:51.452') update system_books set isborrowed=0

where bookid='5455515' and isborrowed='1'

insert into borrow_record(bookid,readerid,borrowdate) values('015115','X05620204','2007-10-21 12:11:51.452') update system_books set isborrowed=0

where bookid='015115' and isborrowed='1'

数据库课程设计例子(3).doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/wenku/131701.html（转载请注明文章来源）

上一篇：2014-2020年中国纤维素酒精行业研究与投资前景预测报告
下一篇：2016-2022年中国漏电断路器市场运营态势与市场商机分析报告