mysql使用

查询

SELECT column_name,column_name FROM table_name

　　

添加

INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );

　　

删除

DELETE FROM table_name [WHERE Clause]

　　

修改

UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]