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