数据库查询语句和导入导出命令
上一篇 /
下一篇 2010-06-28 17:01:49
/ 个人分类:数据库导入导出命令和查询语句
select * from feepropertyclass;/*z整个表有18条记录*/
select * from (select rownum x,feepropertyclass.* from feepropertyclass) where x in (4,5);/*整个表中第4,5条数据*/
select * from (select rownum x,feepropertyclass.* from feepropertyclass) where x<6;/*整个表中前5行数据*/
select * from (select rownum x,feepropertyclass.* from feepropertyclass) where x>6;/*整个表中7行以后的数据*/
指定表备份
exp user/passwd@sid tables=tablename rows=y indexs=n file=name.dmp
指定用户备份
exp user/passwd@sid wner=i.cd feedback=5000 file=name.dmp
全库备份
exp user/passwd@sid feedback=5000 fully=y file=name.dmp
指定表恢复
imp user/passwd@sid table=tablename igore=y feedback=5000 file=name.dmp
整个库恢复
imp user/passwd@sid feedback=5000 full=y file=name.dmp
收藏
举报
TAG: