table same structured but differrent name

[kirkuk_um]

hi all..can anybody help me..

let say i have 1 .sql file which generate 1 table from my database. the table name is payment_temp..

and i have to insert the data from payment_temp.sql into payment table which is payment table have same structured like payment_temp table.

How can i insert data from payment_temp.sql into payment table because the payment_temp.sql will generate "INSERt INTO PAYMENT_TEMP ............. " script not "INSERT INTO PAYMENT.............."

for ur info..i used MYDump to generate the .sql file and MyScript to add my data from .sql file


thx to all..

[Antaeus]

You can do this changing table name in the SQL script manually.
The second way is usage of INSERT ... SELECT command of the MySQL Server. For more information please see this topic of MySQL Reference Manual.