SQL语句（一）

 在线学SQL：https://www.jianshu.com/p/723e8bd6c5c8

https://www.codecademy.com/courses/learn-sql/lessons/manipulation/exercises/sql?action=resume_content_item

• CREATE TABLE creates a new table.

CREATE TABLE table_name (
   column_1 data_type, 
   column_2 data_type, 
   column_3 data_type
);

CREATE TABLE celebs (
   id INTEGER, 
   name TEXT, 
   age INTEGER
);

• INSERT INTO adds a new row to a table.

INSERT INTO celebs (id, name, age) 
VALUES (1, 'Justin Bieber', 22);

• SELECT queries data from a table.

SELECT name FROM celebs;

SELECT * FROM celebs;

• ALTER TABLE changes an existing table.

ALTER TABLE celebs 
ADD COLUMN twitter_handle TEXT;

• UPDATE edits a row in a table.

UPDATE celebs 
SET twitter_handle = '@taylorswift13' 
WHERE id = 4; 

• DELETE FROM deletes rows from a table.

DELETE FROM celebs 
WHERE twitter_handle IS NULL;