- 1、本文档共19页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
数据库语句习题(Database statement exercises)
The third chapter is data operation and transaction processing
1. insert the data in the appendix B table of the reference materials. (keep the inserted SQL text)
B.1 insert into tbl_customer (Cid, Customer, Customer_name, Address, City, State, Zip) values (1,1001, three, Baixia District, Nanjing, Jiangsu,210000);
Insert, into, tbl_customer (Cid, Customer, Customer_name, Address, City, State, Zip), values (2,1002, ` Li four , ` Xuhui District, ` Shanghai , ` Shanghai, `110000);
B.2 insert, into,30.95, tbl_books, values (1,1059831198), 10 minutes of body composition in a day,2001-01-21,4,18.75, ` health;
Insert, into, tbl_books, values (2,0401140733, Mickeys revenge,2001-12-12,1,14.2,22, family life );
B.3, insert, into, tbl_orders, values (1000,1005,2003-03-31,2003-04-01,, Olympic Sports street, Nanjing, Jiangsu,210019);
Insert, into, tbl_orders, values (1001,1010,2003-03-31,2003-04-01,, and will street,, Jiangsu,210001);
B.4, insert, into, tbl_orderitems, values (1000,1,3437212490,1);
Insert, into, tbl_orderitems, values (1001,1,9247381001,1);
B.5, insert, into, tbl_author, values (S100, ` Xue Ming);
Insert, into, tbl_author, values (J100, Chen Hong);
B.6, insert, into, tbl_bookauthor, values (1,1059831198,S100);
Insert, into, tbl_bookauthor, values (2,1059831198,P100);
B.7, insert, into, tbl_publisher, values (1, Xinhua Publishing House, Chen Ming,000-714-8321);
Insert, into, tbl_publisher, values (2, Yangzi Publishing House , Zhang Yi ,010-410-0010);
B.8, insert, into, tbl_promotion, values (bookmarks,0,12);
Insert, into, tbl_promotion, values (book title tag,12.01,25);
2. refer to the appendix B, modify the customer information of Zhu three, the address becomes Xuhui District, the city becomes Shanghai, the province becomes Shanghai, the postcode becomes 110000, and the recommended member becomes Chen three.
Answer: update, tbl_customer, set, Address=, Xuhui District, City=, Shanghai, State=, Shanghai, Zip=110000, where, Cus
您可能关注的文档
- 我的叔叔于勒 续写(My uncle Jules writing).doc
- 我的小学作文课(My primary school composition lesson).doc
- 我的学车故事(My story starts).doc
- 我的载体构建心得(My carrier construction experience).doc
- 我的自我评价英文简历(My self-assessment English resume).doc
- 我对贝多芬的理解(My understanding of Beethoven).doc
- 我的渣打银行实习经历(内含四大求职面经(My internship with Standard Chartered Bank (including four job applicants)).doc
- 我对自己总是没信心感觉自己很失败!(I always have no confidence in myself, I feel I am a failure!).doc
- 我对体育新课改的理解(My understanding of the new curriculum reform in Physical Education).doc
- 我国标准化发展战略及相关支持政策(Standardization development strategy and related supporting policies in China).doc
- 福建省邵武市四中学片区达标名校2024届中考化学最后一模试卷含解析.doc
- 山东省临沂市沂南县重点达标名校2024届中考适应性考试化学试题含解析.doc
- 2024届浙江省嘉兴地区达标名校中考猜题化学试卷含解析.doc
- 2024届山东省菏泽市单县市级名校中考化学最后一模试卷含解析.doc
- 上海市建平西校2024届中考适应性考试化学试题含解析.doc
- 江苏省南京市六校联考2024年中考联考化学试卷含解析.doc
- 江苏省扬州市江都区城区重点名校2024届中考考前最后一卷化学试卷含解析.doc
- 郑州二中学2024届中考化学五模试卷含解析.doc
- 2024届湖南省张家界市永定区重点中学中考化学最后冲刺模拟试卷含解析.doc
- 河北省石家庄市43中学2024年中考化学模拟试题含解析.doc
文档评论(0)