Data

Select all data

SELECT \* FROM <table_name>; 

Read one row of data

SELECT \* FROM <table_name> LIMIT 1; 

Search for data

SELECT \* FROM <table_name> WHERE <column_name> = <value>; 

Insert data

INSERT INTO <table_name> VALUES( <value_1>, <value_2> ); 

Update data

UPDATE <table_name> SET <column_1> = <value_1>, <column_2> = <value_2> WHERE <column_1> = <value>; 

Delete all data

DELETE FROM <table_name>; 

Delete specific data

DELETE FROM <table_name> WHERE <column_name> = <value>;