YES/NO boolean field

[phpatrick]

Hi,

Which datatype do you have to chose in a MySql field that represent a YES/NO (boolean) field in access.

e.g. a field where you can mark is he a member or not ?

 

[Tarwn]

While nothing in the world quite works like an MS Access Yes/No field, you should be able to use either a bool, tinyint(1), or enum type to satisfy your requirements.

Of course I could be wrong, so it might be a good idea to check the correct forum before taking my word for it: forum436

(and yes, I know that bool IS a tinyint(1), but this isn't the MySQL forum, so I figured I was allowed to state them both)

 

[phpatrick]

thanks,
I add MySql to my Threadminder.