书店销售管理子系统数据库设计(11)

insert into borrow_record(bookid,readerid,borrowdate) values('15154656','001456','2007-12-28 14:11:51.312') update system_books set isborrowed=0

where bookid='15154656' and isborrowed='1'

insert into borrow_record(bookid,readerid,borrowdate) values('565800020','008415','2007-08-28 15:11:31.512') update system_books set isborrowed=0

where bookid='565800020' and isborrowed='1'

4.结果数据处理

4.1单表查询

4.1.1表book_style中查询演示

:

图４-1 表book_style中内容