第2题:
建立数据库表book,并通过页面,实现和完成对书籍信息的增加、删除、修改和查询的管理功能。
createdatebasebooksmgt;usebooksmgt;createtablebook(bookidchar(6)notnull,booknamevarchar(30)null,pricefloat(5,2)null,primarykey(bookid));createtableauthor(authoridchar(6)notnull,authornamevarchar(10)notnull,bookidchar(6)notnull,phonevarchar(15)notnull);altertableauthoraddconstraintFK_book_authorforeignkey(bookid)referencesbook(bookid);insert into book values('s10123', '科学探秘',52.00);update book set price=49.00 where bookid='s10123';delete from book wherebookid='s10123';