添加数据
insert into dept(deptno,dname,loc)values(50,'LOL学院','北京')
insert into dept values(60,'吃鸡学院','广州')
select *from dept order by deptno
当插入全部数据时,可以省略前面的括号
需要进行手动提交,数据库的内容才会发生改变,并且有回滚功能
删除数据
--删除指定数据
delete from dept where deptno=50
--删除所有数据
delete from dept
--删除所有数据,比delete效率高
truncate table dept
更新数据
测试插入一条数据,然后更改
insert into dept values(50,'LOL','武汉')
update dept set dname='java学院',loc='上海' where deptno=50
select *from dept
备份数据
--数据备份不会备份表的约束
--全部备份
create table deptBak as select *from dept
select *from deptBak
create table deptBak2 as select deptno,dname from dept
直接插入备份
delete from deptBak
insert into deptBak select *from dept