Insert records from one table to another 1

[gxydas]

Hi all,

I have two database tables. One in paradox (tb1) and one in mysql (tb2).

I can see the records of each table.

I want to create a query that passes the records from to tb1 to tb2.

How can I do that?

Thanks.

 

[schu]

You should look at the batch move command

 

[gxydas]

Could you be more specific on how to use batch move command?

 

[schu]

Sorry not command, It is a component, which allows quick copy from one table to another.
Coming to think of it, it might not work with cross database. You should look at it anyway.

Of course you can use use a query, to extract then a loop to insert. Slower but works.

Query1.SQL.ADD('SELECT * from TableA');
query1.open;
while not query1.eof do
begin
SQLStr:='Insert into TableB Values('+Query1.fields[0].asstring.......;
if query2.active then Query2.close;
Query2.sql.clear;
Query2.sql.add(SQLStr);
Query2.execsql;
end

you get the idea.

 

[gxydas]

I got the idea.

Thanks schu