Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error using copy table function

andrea.petracca's profile image andrea.petracca posted 6 days ago in General Permalink

Hi, i'm using the HeidiSQL version 10.3.0.5813, from today the function to copy table (Right-click on the table name --> New --> Copy table) does not work and always returns the error popup. ErrorSQL (1064): You have an error in your SQL syntax;........

ansgar's profile image ansgar posted 6 days ago Permalink

Please report the server type, and be sure to run the latest HeidiSQL release.

andrea.petracca's profile image andrea.petracca posted 6 days ago Permalink

The HeidiSQL version is 10.3.0.5813 (64 bit) running on Windows 10 professional (64 bit), the server is mysql 5.1.66 (x86_64).

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Code modification/commit 245e033 from Ansgar Becker <anse@heidisql.com>, 6 days ago, revision 5814
Detect empty string without quotes as text default type. See https://www.heidisql.com/forum.php?t=35365
ansgar's profile image ansgar posted 6 days ago Permalink

Should be fixed in the next build.

There may be more bugs like this in the current builds, as I am working on a larger code enhancement for parsing a table structure, and on SQLite in general.

Please login to leave a reply, or register at first.