Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Exporting Result Set As Sql Results In A Missing Table Name

forums forums SQLyog SQLyog: Bugs / Feature Requests Exporting Result Set As Sql Results In A Missing Table Name

Tagged: 

This topic contains 1 reply, has 0 voices, and was last updated by  peterlaursen 6 years, 9 months ago.

  • Author
    Posts
  • #12722

    redAppleCore
    Member

    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 ,

    `Mobile` tinyint

    );

    insert into “ (`BrowserID`, `Platform`, `Browser`, `Version`, `Mobile`) values('0','Unknown','Unknown','0','0');

    Thanks!

  • #33562

    ashwin
    Member

    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.

  • #33563

    peterlaursen
    Participant

    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.