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
>
> | 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 specify the new column parameters:
>
> alter table sometable modify tooshortcolumn varchar(255);
>
> note: unlimited column length not exists.
> if you need a realy BIG character type column try the text types
> (text mediumtext, etc...)
> see mysql doc: 7.3 Column types
>
> sorry i can't understand this:
> | Make a column have a check box instead of characters(VARCHAR...)
>
> bye,
>
> ati
>
> ---------------------------------------------------------------------
> 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