[bug]

[expired user #9570]'s profile image [expired user #9570] posted 8 years ago in General Permalink

Trying to copy table (right click on table -> create new -> table copy) to another db.

There is column of type 'BIT' in table. HeidiSQL generate and trying to execute:

CREATE TABLE ...
...
"Manual" BIT NOT NULL DEFAULT b'0',
...

This syntax causes error:

SQL Error (128): The name "b" is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

Correct syntax is:

CREATE TABLE ...
...
"Manual" BIT NOT NULL DEFAULT 0,
...

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