首页 > 编程知识 正文

plsql导出insert语句,oracle导出insert语句

时间:2023-05-03 09:07:34 阅读:127678 作者:2168

iamtryingtoexportthedatabaseihaveatmysqlworkbenchbutiamhavingtroublestogeneratetheinsertstatementsonthe.sqlfile。

I order to export the data,idothereverseengineeringforthedatabaseiwanttoexport.then,i go to

file/export/forwardengineersqlcreatescript

在there中和在,iselecttheoptiongenerateinsertstatementsfortables。

theresultonlygeneratesthecodeforthecreatetables。

isthereanywaytocreatetheinsertstatementsforthedata?

For older versions:

openmysqlworkbenchomemanageimport/export (轻型底部)/selectrequireddbadvanceexportsoptionstabcompleteinsert [已选中]

For 6.1 and beyond,thanks to ryandlf:

clickthemanagementtab (基本方案) and choose Data Export。

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。