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.
>
> - Deryck H
> - http://www.comp-u-exchange.com
> ----- Original Message -----
> From: "Mike Wexler" <[EMAIL PROTECTED]>
> To: "Deryck Henson" <[EMAIL PROTECTED]>
> Cc: "MySQL" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 05, 2001 10:19 PM
> Subject: Re: How to do simple stuff
>
> >
> >
> > Deryck Henson wrote:
> > >
> > > How do I::
> > >
> > > Add a column
> >
> > ALTER TABLE myTable ADD COLUMN myColumn VARCHAR(27)
> >
> > > Alter a table to fit a different character lengths (say...unlimited in a
> 1
> > > column)
> >
> > ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT
> >
> > > or
> > > alter column to accept an unlimited amount of characters
> >
> > ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT
> >
> > > Make a column have a check box instead of characters(VARCHAR...) or date
> > > (DATE)
> >
> > mysql doesn't control your UI. You would have to reconfigure whatever
> > software is presenting your UI.
> >
> >
> > >
> > > thanx
> > > - Deryck H
> > > - http://www.comp-u-exchange.com
> > >
> > > ---------------------------------------------------------------------
> > > 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
> >
> > ---------------------------------------------------------------------
> > 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
---------------------------------------------------------------------
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
