[RESOLVED] How to do 2-in-1 Task ?!

Hi!

I have 2 tables with same structure...
Now i want to have a query run and copy 1 single record from 1 table to second table !!

How do i do that ?

Thanks!

If you are using mysql then you can use the INSERT INTO ... SELECT query.

Code:

---

INSERT INTO dst (col1,col2,col3) SELECT col1,col2,col3 FROM src;

---

Oh goodie very thansk! :)