MySQL add-on-change search and delete

Increase and deletion can be expressed by curd: Create Modify: Update lookup: Read Delete: delete

Add Create:insert + table name +values+ (information);

insert+ Table name (field name 1, field name 2) +value+ (information)

Delete delect:delect field = ' info ' from + table name where field name = information and/or field name = Information

Find Read:select * from + table name from the entire table;

Select field 1, Field 2 + from table name + where + field +like+ "% keyword%";

SELECT * from + table name +order by + field +ase (default from low to High sort)/desc (from high to low);

Modify update:update+ table name +set+ field = Info

updae+ table name +set+ field = information +where+ field = Information

Look very simple, write up the hand is very raw ah, but also need to contact more than the line ....

MySQL add-on-change search and delete