Zoo tutorials:
[
SQL
|
CSS
|
Linux
|
Java
|
XML
]
Using:
SQL
zoo.net
Quick Ref.
SELECT
FUNCTIONS
SELECT
WHERE
SELECT
GROUP BY
SELECT
JOIN
SELECT
SELECT
INSERT
VALUES
INSERT
SELECT
UPDATE
DELETE
CREATE
TABLE
CREATE
VIEW
CREATE
INDEX
DROP
ALTER
TABLE
DROP
The table
games
shows the year and the city hosting the Olympic Games.
games
yr
city
2000
Sydney
2004
Athens
2008
Beijing
2012
London
You can drop a table, a view or an index. The data will be lost.
DROP VIEW old_games; DROP INDEX gamesIdx ON games; DROP TABLE games;
DROP VIEW old_games; DROP INDEX gamesIdx; DROP TABLE games;
CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012); CREATE VIEW old_games AS SELECT yr,city FROM games WHERE yr<2006; CREATE INDEX gamesIdx ON games(city,yr);
DROP VIEW old_games; DROP INDEX gamesIdx ON games; DROP TABLE games;
Results
See also:
CREATE
DELETE