Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Exporting Result Set As Sql Results In A Missing Table Name
This topic contains 1 reply, has 0 voices, and was last updated by peterlaursen 6 years, 9 months ago.
For SQLYog 10.11 if you do a query such as “SELECT * FROM temp” and then export that data as SQL the table name will be missing in the file for the insert statements and the create table statement eg:
create table “ (
`BrowserID` smallint ,
`Platform` varchar ,
`Browser` varchar ,
`Version` varchar ,
insert into “ (`BrowserID`, `Platform`, `Browser`, `Version`, `Mobile`) values('0','Unknown','Unknown','0','0');
Issue confirmed. Read-only 'Export as SQL' was trimming the table name. Reproducible since v10. We will fix it in the next public release(Today or Tomorrow).
You can change to Edit mode and export as SQL which will export with table name.
Thank you for reporting.
Fixed in 10.12 just released.
Please refer: http://www.webyog.com/blog/2012/06/28/sqlyog-mysql-gui-10-12-released/
You must be logged in to reply to this topic.