I can create a default value for a bit field in code, but I can't seem to do it in the GUI for creating/modifying table structures.
CREATE TABLE `test` (
`UserName` VARCHAR(50) NULL,
`ActiveFlag` BIT NOT NULL default b'1')
When I put in 1 or '1' or b'1' I keep getting "SQL Error (1067): Invalid default value for 'ActiveFlag'
How do I achieve this?
Thanks,
--Mike
How do define a bit field's default value in the GUI?
Thanks, jfalch. I noticed it was merged with 1160 (https://code.google.com/p/heidisql/issues/detail?id=1160) and I have clicked on the Star to add my vote for this being added/fixed.
Please login to leave a reply, or register at first.