[Bug] Comments exported incorrectly

user posted 6 months ago in General


Comments are exported in the following format: /!40000 ALTER TABLE test /; -- HeidiSQL Version:

Running this causes the SQL error "Table doesn't exist"

To resolve: Add a space after the /, example: / !40000 ALTER TABLE test */;

ansgar posted 6 months ago

No, comments are exported with an asterisk after the slash:

/*!40101 SELECT 1 */;

Adding a space turns such a conditional comment into an ordinary comment not being executed on any server:

/* !40101 SELECT 1 */;

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