Yes/No True/False Datatypes

[VeronicaCBurgess]

I am fairly new to MySql. My question is this: is there a Yes/No or True/False datatype in MySql?

I have a table with a column "inactive" which I would like to have a checkbox for in Dreamweaver. Can anyone shed some light on this?

 

[tshot]

have u checke the enum data type. here column values may be assigned only one menber of the value list

so u can have coloumn name status defined as

status enum("TRUE", "FALSE")

take care of double quotes in definition

and for usage u can test/assgin the value TRUE or FALSE to status field.
u can go upyo 65536 memebers in enum list

as of testing column incactive u can doit in the whatever programming language u are using by checkibng the value of status field






----------------
ur feedback is a very welcome desire

 

[LittleSmudge]

There is a BOOLEAN data type in the spec - which actually gets stored as a single bit integer value TINYINT(1)

So you have

0    meaning     False, No, Wrong, GoAway, Inactive
-1   meaning     True, Yes, Correct, Welcome, Active

or whatever other interpretations you want to place on the T/F alternatives that a Boolean value gives you.



'ope-that-'elps.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[VeronicaCBurgess]

Thank you LittleSmudge. That worked out just fine.