SQL/Databases

Question 1

How do you create a table?

Answer 1

CREATE TABLE tablename (
columnname valuetype,
columnname2 valuetype,
);

Question 2

How do you delete a table?

Answer 2

DROP TABLE tablename;

Also exists:

DROP TABLE IF EXISTS test;

Question 3

How do you add rows to a table?

Answer 3

INSERT INTO tablename VALUES (value,value,value);

for specific columns:

INSERT INTO tablename (columnname, columnname) VALUES (value,value);

To insert Null:

INSERT INTO tablename DEFAULT VALUES;

Question 4

How do you delete rows from a table?

Answer 4

DELETE FROM tablename WHERE clause;

Question 5

How do you change existing values in a row?

Answer 5

UPDATE tablename SET field1 = somevalue, field2 = somevalue WHERE clause;