What value could I insert into a bit type column?

Question

statue type the situation I am trying to insert or edit the bit value to "0" or "1", but either returns me a blank.

Could someone tells me how to insert the value in it?

Also, Is that possible to not use bit type but Boolean? I see there's a Boolean type in the list of types

Thanks

Hi, I have uploaded the picture, the cell in the table is blank, but I have tried several times, add, update, all take effect, but cell keeps blank...

PHPMyAdmin isn't a database, it's an interface. If you're using PMA, your database is MySQL. Also, it's not made by Hostgator (is that your hosting company?), it's a widely-used open-source project: http://www.phpmyadmin.net/home_page/index.php — Adrian, Apr 02 '13 at 12:59

score 31 · Accepted Answer · edited May 23 '17 at 12:18

31

Generally speaking, for boolean or bit data types, you would use 0 or 1 like so:

UPDATE tbl SET bitCol = 1 WHERE bitCol = 0

See also:

edited May 23 '17 at 12:18

Community

1
1

answered Apr 01 '13 at 20:27

Kermit

33,827
13
85
121

2

Hi this one does not work, I tried lots of work. The code take affect, but the value it appears in the table is a blank. I don't know why... – James Chen Apr 01 '13 at 22:07
@JamesChen What is the data type of the `statue` column? – Kermit Apr 01 '13 at 22:17
I set as bit, it appears bit(1) in it – James Chen Apr 01 '13 at 22:19
@JamesChen Drop the `DEFAULT` value of `NULL`. – Kermit Apr 01 '13 at 22:23
Hi I just found although it displayed as blank, the value is still 1! I dont know why, probably system error? Anyway thanks for helping :-) – James Chen Apr 01 '13 at 22:39
@JamesChen Long time ago since this post but could it be that the select shows nothing? Then see this link https://stackoverflow.com/questions/14248554/cant-see-mysql-bit-field-value-when-using-select – Valter Ekholm May 06 '19 at 07:33

score 5 · Answer 2 · answered Apr 01 '13 at 20:30

5

If you're using SQL Server, you can set the value of bit fields with 0 and 1

or

'true' and 'false' (yes, using strings)

...your_bit_field='false'... => equivalent to 0

answered Apr 01 '13 at 20:30

Alcides Queiroz

9,456
3
28
43

Same happened to me, if i do select * from the table, the field looks empty – Fernando Gabrieli Jul 25 '19 at 19:52

score 5 · Answer 3 · answered Aug 15 '14 at 10:56

5

Your issue is in PHPMyAdmin itself. Some versions do not display the value of bit columns, even though you did set it correctly.

answered Aug 15 '14 at 10:56

Fer

4,116
16
59
102

What value could I insert into a bit type column?

3 Answers3