Re: changing some tables

2001-03-01 Thread Joseph Bueno
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 o

changing some tables

2001-03-01 Thread Marcos
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.