添加数据
INSERT语句:
INSERT INTO table_name(column1,column2.....) VALUES(values1,values2)
字段和数据一一对应
修改数据
UPDATE table_name SET column1=values1,column2=values2 [WHERE conditions]
删除数据
DELETE FROM table_name [WHERE conditions]
复制表数据
在创建表时复制:
CREATE TABLE table_new AS SELECT column1,....|* FROM table_name;
在添加时复制:
INSERT INTO table_new [(column1,....)] SELECT column1,...|* FROM table_old