SQL语句-插入记录，修改记录，删除记录与查询记录

[quote]插入记录：[/quote]

INSERT INTO tablename (field1, field2, field3, field....n) VALUES (value1, value2, value3, value....n);

[quote]更新记录：[/quote]

UPDATE tablename SET field1=value1,field2=value2,field3=value3 [WHERE condition]

WHERE condition可选。

[quote]删除记录：[/quote]

DELETE FROM tablename [WHERE condition]

WHERE condition可选。


[quote]查询记录：[/quote]

SELECT * FROM tablename [WHERE condition]

WHERE condition可选。