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,
...