Re: copy columns in tables

[robert bakaric]

something like :

insert into table1.namea
select NAMEA
from table0

where you have to have table1 and it's coloumn created so

use db;
drop table table1;

create table table1 (
namea varchar (255)
);

insert into table1 (namea)
select NAMEA
from table0 ;

---
if this is what you were thinking of ? also you could search if there is a special copy function to shorten this code