PHP database additions and deletions to change the operation

1. INSERT statement: "INSERT into data table name (Field 1, Field 2,....) VALUES (" Value 1 "," Value 2 ",.....)"

For example: $sql = "INSERT into message (title,content,who) VALUES (' Message title ', ' Message content ', ' message person ')";

2. DELETE statement: "Delete from data table name where field = ' condition '"

For example: $sql = "Delete from message where id= ' 1";//delete id=1 data

3. Lookup Statement: "SELECT * from table name where condition (optional)"

For example: $sql = "SELECT * from Message";//query All data

4. Modify Statement "Update table name set field 1 = ' value 1 ', field 2 = ' Value 2 ', field 3 = ' Value 3 ' where field = ' condition '"

For example: $sql = "Update message set title= ' modify title ', content= ' modify content ', who= ' modify name ' where id= ' 1 '";

PHP database additions and deletions to change the operation