mysql数据库
crazy__chen
只要有一个人爱我,懂我,愿意等我,我便勇往直前,无所不能。
展开
-
sqlzoo练习答案--SELECT basics/zh
這個教程介紹SQL語言。我們會使用SELECT語句。我們會使用WORLD表格namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000AndorraEurope468原创 2016-01-08 15:08:21 · 5032 阅读 · 0 评论 -
sqlzoo练习答案--SELECT names/zh
namecontinentAfghanistanAsiaAlbaniaEuropeAlgeriaAfricaAndorraEuropeAngolaAfrica....name:國家名稱continent:洲份1、你可以用WHERE name LIKE 'B%'來找出以 B 為開首的國家。%是萬用字元,可以用代表任何字完。找出以 Y 為開首的國家。SELECT name FROM world W原创 2016-01-08 15:24:21 · 13563 阅读 · 0 评论 -
sqlzoo练习答案--SELECT from Nobel Tutorial/zh
nobel 諾貝爾獎得獎者我們繼續練習簡單的單一表格SQL查詢。這個教程是有關諾貝爾獎得獎者的:nobel(yr, subject, winner)yrsubjectwinner1960ChemistryWillard F. Libby1960LiteratureSaint-John Perse1960MedicineSir Frank Macfarlane Burnet1960MedicineP原创 2016-01-08 16:18:01 · 8798 阅读 · 2 评论 -
sqlzoo练习答案--SELECT within SELECT Tutorial
This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope2874原创 2016-01-12 14:18:09 · 13441 阅读 · 1 评论 -
sqlzoo练习答案--SUM and COUNT
World Country Profile: Aggregate functionsThis tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many values and delivers just one value. For example the fu原创 2016-01-12 15:43:05 · 5862 阅读 · 0 评论 -
sqlzoo练习答案--The JOIN operation
gameidmdatestadiumteam1team210018 June 2012National Stadium, WarsawPOLGRE10028 June 2012Stadion Miejski (Wroclaw)RUSCZE100312 June 2012Stadion Miejski (Wroclaw)GRECZE100412 June 2012National Stadium,原创 2016-01-13 15:35:17 · 11861 阅读 · 4 评论 -
sqlzoo练习答案--More JOIN operations
Movie DatabaseThis tutorial introduces the notion of a join. The database consists of three tables movie , actor and casting .movieactorcastingididmovieidtitlenameactoridyr orddirector budget gross原创 2016-01-13 23:54:54 · 7075 阅读 · 0 评论 -
sqlzoo练习答案--Using Null
teacheriddeptnamephonemobile1011Shrivell275307986 555 12341021Throd275407122 555 19201031Splint2293 104 Spiregrain3287 1052Cutflower321207996 555 6574106 Deadyawn3345 ...deptidname1Computing2Design3En原创 2016-01-14 15:32:11 · 4758 阅读 · 1 评论 -
mysql优化
u Mysql数据库的优化技术对mysql优化时一个综合性的技术,主要包括 a: 表的设计合理化(符合3NF)b: 添加适当索引(index) [四种: 普通索引、主键索引、唯一索引unique、全文索引]c: 分表技术(水平分割、垂直分割)d: 读写[写: update/delete/add]分离e: 存储过程 [模块化编程,可以提高速度]f: 对mysql配置优化原创 2014-06-28 17:23:30 · 1730 阅读 · 0 评论 -
sqlzoo练习答案--Self join
stops(id, name)route(num,company,pos, stop)stopsrouteidnumnamecompany pos stop 1、How many stops are in the database.select count(id) from stops2、Find the id value for the stop 'Craiglockhart'select原创 2016-01-14 16:25:59 · 9484 阅读 · 2 评论