Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Easy language sQL statements: query, add, delete, modify. How to write the code
Easy language sQL statements: query, add, delete, modify. How to write the code
10, Description: Several simple and basic sql statements.

Select: select * from table1where ID = 1 (ID = 1 is a conditional statement, customized according to your own situation).

Insert: Inserts a value (value 1, value 2) into the table 1 (field 1, field 2).

Delete: delete from the table 1 where range.

Update: updatetable1setfield1= value1where range.

Search: the syntax of select * from table 1 where field1like'% value1%'-like is very subtle, please check the information!