Marcos wrote:
>
> hi,
>
> i have a table like that:
>
> CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY
> KEY(login));
>
> i have lot of info inserted already in that table. And i would like
> to add some more attributes. how can i do it, in order to maintain older
> info?
>
> drop the table.
> CREATE TABLE user ( login varchar(50), pass varchar(50), att1
> varchar(10), att2 int(4), PRIMARY KEY(login));
> mysqldump -u user -p password table > table.txt
>
> is this right?
>
> regards,
>
> marcos lloret
> [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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
Hi,
Look at ALTER TABLE, it is in the manual ;)
Regards
--
Joseph Bueno
NetClub/Trader.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
