MySQL command reference

main.sql

# Select, insert, update, delete
SELECT * FROM `my_table` WHERE `my_field` = 'my_value';

INSERT INTO `my_table` (my_field, another_field) VALUES ('myFieldValue', 'AnotherFieldValue');

UPDATE `my_table` SET `my_field` = 'aNewValue';

DELETE FROM `my_table` WHERE `my_field` = 'a_special_value';

# Get the schema of sorts for a table
SHOW COLUMNS FROM `my_table`;