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