创建表
CREATE TABLE 表名(...);
插入
INSERT INTO 表名(...);
修改
将SALARY表中EMPLOYEEID为011112的INCOME改为5890:
UPDATE SALARY
SET INCOME=5890
WHERE EMPLOYEEID='011112';
将SALARY表中所有INCOME增加100:
UODATE SALARY
SET INCOME=INCOME+100;
删除
删除SALARY表中的一行记录:
DELETE FROM SALARY WHERE EMPLOYEEID='011112';
删除SALARY表:
DELETE TABLE SALARY;