DML数据操作语言练习

--创建表T_HQ_BM2
--create table t_hq_bm2 as select * from t_hq_bm;
commit;

--添加行内容
--insert into t_hq_bm2 values ('107','研发部','147258369');
commit;

--删除部门编码为107的行
--delete t_hq_bm2 where bumenbm = '107';
commit;

--添加行内容
--insert into t_hq_bm2 (bumenbm,lianxidh) values ('107','147258369');
commit;

更新所有的联系电话为123456789
update t_hq_bm2 set lianxidh = '123456789';
commit;

--更新部门编码为106的联系电话为147258369
update t_hq_bm2 set lianxidh = '147258369' where bumenbm = '106';
commit;

--删除表内容
delete t_hq_bm2;
commit;

 

转载于:https://www.cnblogs.com/shadowduke/p/4912742.html