SELECT basics/zh

From SQLZOO
Revision as of 12:00, 5 January 2016 by Kenlyl (talk | contribs) (Introducing the world table of countries)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introducing the world table of countries

這個教程介紹SQL語言。我們會使用SELECT語句。on the table France:

Summary

The example uses a WHERE clause to show the population of 'France'. Note that strings (pieces of text that are data) should be in 'single quotes';

Modify it to show the population of Germany

SELECT population FROM world
  WHERE name = 'France'
SELECT population FROM world
  WHERE name = 'Germany'