SQL

Question 1

Insert a row into a table

Answer 1

INSERT INTO tablename (field1, field2) VALUES (“value1”, “value2”)

Question 2

Delete a row from a table

Answer 2

DELETE FROM tablename WHERE field=”field”

Question 3

Group results by a field

Answer 3

SELECT * FROM tablename GROUP BY field

Question 4

Update a row where id=1

Answer 4

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

Question 5

Order by a field

Answer 5

SELECT * FROM tablename ORDER BY field

Question 6

Join tables together

Answer 6

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