Mike Wexler wrote:
> Deryck Henson wrote:
> >
> > Let me rephrase that checkbox one::
>
> >
> > TRUE or FALSE
>
> ALTER TABLE myTable CHANGE COLUMN myColumn TINYINT(1)
>
> And you use 1 for TRUE and 0 for FALSE.
Or ENUM:
ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
Of course if you are using this to drive a web page Mike's solution is better.
Or you would want to enum( 1, 0 ) or enum( '1', '' );
--Bill
---------------------------------------------------------------------
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