![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
基础--2.数据库(Mysql)
咸鱼的梦想
这个作者很懒,什么都没留下…
展开
-
SELECT杂谈二
关于SELECT转载 2017-03-31 16:31:31 · 281 阅读 · 0 评论 -
sqlzoo练习答案--SELECT basics/zh
這個教程介紹SQL語言。我們會使用SELECT語句。我們會使用WORLD表格namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope287482831741129600000转载 2017-08-07 15:29:46 · 319 阅读 · 0 评论 -
sqlzoo练习答案--SELECT from Nobel Tutorial/zh
我們繼續練習簡單的單一表格SQL查詢。這個教程是有關諾貝爾獎得獎者的:nobel(yr, subject, winner)yrsubjectwinner1960ChemistryWillard F. Libby1960LiteratureSaint-John Perse1960Medicin转载 2017-08-07 15:31:20 · 1079 阅读 · 0 评论 -
sqlzoo练习答案--SELECT within SELECT Tutorial
This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.namecontinentareapopulationgdpAfghanistanAsia65223025转载 2017-08-07 15:32:39 · 523 阅读 · 0 评论 -
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 th转载 2017-08-07 15:35:56 · 663 阅读 · 0 评论 -
sqlzoo练习答案--The JOIN operation
idmdatestadiumteam1team210018 June 2012National Stadium, WarsawPOLGRE10028 June 2012Stadion Miejski (Wroclaw)RUSCZE100312 June 2012Stadion Miejski (Wrocla转载 2017-08-07 15:37:32 · 1798 阅读 · 0 评论 -
sqlzoo练习答案--More JOIN operations
Movie DatabaseThis tutorial introduces the notion of a join. The database consists of three tables movie , actor and casting .movieactorcastingididmovieidtitle转载 2017-08-07 15:39:05 · 782 阅读 · 0 评论 -
sqlzoo练习答案--Using Null
teacheriddeptnamephonemobile1011Shrivell275307986 555 12341021Throd275407122 555 19201031Splint2293 104 Spiregra转载 2017-08-07 15:40:15 · 401 阅读 · 0 评论 -
sqlzoo练习答案--Self join
stops(id, name)route(num,company,pos, stop)stopsrouteidnumnamecompany pos stop 1、How many stops are in the database.转载 2017-08-07 15:42:26 · 852 阅读 · 0 评论 -
sqlzoo练习答案--SELECT names/zh
namecontinentAfghanistanAsiaAlbaniaEuropeAlgeriaAfricaAndorraEuropeAngolaAfrica....name:國家名稱continent:洲份1、你可以用WHERE name LIKE 'B%'转载 2017-08-07 15:26:06 · 597 阅读 · 0 评论 -
SELECT杂谈一
关于SELECT的使用转载 2017-03-31 15:34:10 · 237 阅读 · 0 评论