DML:数据管理语言
插入(而不是增加):insert into table_name values(.........)
删除:delete from table_name where ...
更新(不是修改):update table_name set id = * where ....
查看:select * from table_name
DDL:数据定义语言
创建表(视图): (1) create table emp()
(2)create view empview
as
select *
from
去掉表:drop table_name
修改表结构:alter table_name add(modify、drop)
查看表结构:desc emps