SQL Flashcards Preview

Linux+ (LXO-104) > SQL > Flashcards

Flashcards in SQL Deck (6):
1

Insert a row into a table

INSERT INTO tablename (field1, field2) VALUES ("value1", "value2")

2

Delete a row from a table

DELETE FROM tablename WHERE field="field"

3

Group results by a field

SELECT * FROM tablename GROUP BY field

4

Update a row where id=1

UPDATE tablename SET field="field" WHERE id=1

5

Order by a field

SELECT * FROM tablename ORDER BY field

6

Join tables together

SELECT * FROM table1 LEFT JOIN table2 ON table1.field1=table2.field2