day 2015.6.08

增加一行

INSERT INTO part VALUES(42,'seats',24.5);

删除一行

DELETE FROM part WHERE description="p";

增加一列

ALTER TABLE orders ADD adderss VARCHAR(20);

删除一列

ALTER TABLE orders DROP adderss;

更新已有行的数据

UPDATE orders SET partnum=20 WHERE quantity=6;