MySQL table operation additions and deletions to check and change

01 Inserting data Insert

INSERT into ' table_name ' (' column01_name ', ' column02_name ', ...) VALUES (VALUE01, VALUE02, ...)

02 Querying Data SELECT

SELECT * FROM ' table_name ' WHERE ' column01 ' = value01 and ' column02 ' = value02 and ...

03 Modifying Data UPDATE

UPDATE ' table_name ' SET ' column01_name ' = new_value01, ' column02_name ' = new_value02, ...

04 Deleting Data Delete

DELETE from ' table_name ' WHERE ' column01_name ' = value01, ' column02_name ' = value02, ...

2014-09-02 14:47:07 at bit/#10/315

MySQL table operation additions and deletions to check and change