Dne 4.3.2010 10:06, korkless napsal(a):

> i have 2 tables in the same db with the same structure.
>
> i need to copy same rows from one table to the other.
>
> it's better if i can do it directly with a query without using procedures (but if it's the unique way it's ok too).
>

INSERT INTO table1 SELECT * FROM table2 WHERE ...

Pepak