Ann Myhre wrote:
>Hi group
>
>Access has a datatype (I don't remember the name) which is a kind of boleaen; it
>represents Yes/No, true or false. When I try to translate that creating a table in
>MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y
>then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result.
>Anyone?
>
Use type `bool'. This is an alias for tinyint(1), with values 0 or 1.
Charlie
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
