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  redAppleCore 6 years, 12 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!

You must be logged in to reply to this topic.