distal-attribute
distal-attribute
distal-attribute
distal-attribute

Error on database rename

sergtop posted 5 years ago in General
When I rename an active DB (edit on DB name) sql like
RENAME TABL;
executed. that is not the correct one. Maybe it is easier to add a menu item - rename instead of edit as Edit copies DB entirely
ansgar posted 5 years ago
Which revision of heidisql.exe did you use? I cannot reproduce that using the latest build.
sergtop posted 5 years ago
rev2820
ansgar posted 5 years ago
Ok, that's a newer build.

You say there that this gets executed:

RENAME TABL;


Is that really true or was that a typo? It should be

RENAME TABLE xyz;

ansgar posted 5 years ago
Eh, sorry, it should have been

RENAME TABLE `xyz` `newdb`.`xyz`;

sergtop posted 5 years ago
there was exactly
RENAME TABL;
in the bottom window
ansgar posted 5 years ago
Fixed in r2858

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