MySQL Query

MySQL Query

1. INSERT

INSERT INTO table_name
VALUES (value1, value2,...)

INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,...)

INSERT table_name set
column1 = value1,
column2 = value2,

2. DELETE

DELETE FROM table_name
DELETE FROM table_name WHERE column = 'value'

3. UPDATE

UPDATE table_name SET
column1 = value,
column2 = value2,...
WHERE column = 'value'

4.ETC

ALTER TABLE table_name AUTO_INCREMENT = X