Flashcards
SQL FLASHCARDS
Cards in this deck (9)
- 1SELECTUSED TO ALLOW SELECTION OF CERTAIN FIELDS FROM A DATABASE
FORMAT:
SELECT column_name,column_name
FROM table_name - 2WHEREUSED TO SELECT SPECIFIC DATA THAT MEETS A CRITERIA.
FORMAT:
WHERE column_name operator_value; - 3ANDUSED TO FILTER MORE THAN ONE REQUIREMENT AT ONCE, ONLY IF BOTH CONDITIONS ARE TRUE
WHERE CITY=GERMANY AND CITY=JAPAN - 4ORGOES HAND IN HAND WITH AND
IF ONE CONDITION IS MET OR THE OTHER
WHERE CITY=JAPAN OR CITY=CHINA - 5ORDER BYSORTS INTO ASCENDING OR DESCENDING ORDER
ORDER BY COLUMN_NAME, ASC|DESC - 6UPDATEUSED TO ALTER RECORDS THAT ALREADY EXIST
UPDATE CUSTOMERS
SET CITY=BRADFORD
WHERE CUSTID='1' - 7DELETEUSED TO DELETE PRE-EXISTING RECORDS
DELETE FROM TABLE_NAME
WHERE SOME_COLUMN = VALUE; - 8INSERT INTOUSED TO INSERT NEW RECORDS
INSERT INTO TABLE_NAME(COLUMN1,...)
VALUES(VALUE1, VALUE2) - 9SYNTAXSEMI-COLON A TTHE END OF EACH STATEMENT.
THIS ALLOWS MORE THAN ONE STATEMENT TO BE EXECUTED AT ONCE
Information
- Description
- Flashcards on SQL FLASHCARDS, created by Kyle Baxter on 03/03/2017.
- Created by
- Kyle Baxter
- Views
- 4
- Rating