At 17:25 06.09.01, you wrote:
>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', '' );
yes, but do *not* use enum('t','f') because with some fo
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 y
http://www.anse.de/mysqlfront/
Use a GUI it's a lot easier
- Original Message -
From: "Attila Soki" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 11:03 PM
Subject: Re: How to do simple stuff
> hi
>
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
Did you read the manual?
> Alter a table to fit a different character lengths (say...unlimited in a 1
> column)
> or
> alter column to accept an unlimited amount of characters
The concept of unlimited characters does not exist in the real w
dnesday, 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
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 unlimit
hi
| Add a column
add an integer column:
alter table sometable add somecolumn int;
add an varchar column:
alter table sometable add somecolumn varchar(255);
see: mysql doc 7.8 Alter table syntax
| Alter a table to fit a different character lengths
|(say...unlimited in a 1 column)
simply spec
