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。