MySQL COPY Record command

[Tracy3e]

I hope this is the best place to post a general MYSQL question. I need to create a 49 field record and I would much rather copy an existing record and modify the fields accordingly.

Is there a copy command in MySQL? I've searched mysql.com but could not find anything - hopefully it's under another name??

Thanks in advance.

 

[CherylD]

That's the exact same thing I am wondering!! Did you have any luck finding out an answer for this?

 

[Cagliostro]

insert into yourtable(colA, colB, colC...)
values (A, B, C...)
Ion Filipski

filipski@excite.com

 

[Tracy3e]

No, I never was able to find out the answer, unfortunately. After I made all the additions, I found out you only have to specify the fields that you care about (as the previous poster mentions) - but still there are a lot of fields to be copied which takes forever. I can't believe you can't copy a record in MySQL??

 

[Cagliostro]

yes
insert into xx
select * from xxx

if selects result has the same number of column as table xx is not problem. Ion Filipski

filipski@excite.com