Sql常用语句

INSERT 

 

INSERT mytable (first_column，second_column，third_column)
VALUES (‘some data'，'some more data'，'yet more data')

 

 

DELETE

 

DELETE FROM `table1` WHERE id=2312
DELETE FROM table1 WHERE id in ("11480","11485")

 

UPDATE

UPDATE table1 SET field1=1 WHERE id = 12378