发布新日志

  • 数据库查询语句和导入导出命令

    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

Open Toolbar