Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Setting default value of BIT in MySQL

dmikester1's profile image dmikester1 posted 2 weeks ago in General Permalink

I have my local DB as MariaDB and am able to set the default value of the BIT column by setting the "Expression" to b'1'

Now I have the prod DB duplicated of that one except it is MySQL. But I cannot figure out how to set the default value to 1. When I try the same thing of setting the "Expression" to b'1', it converts it to "custom text" of 'b\'1\''

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.