Dear Krung,
Why do you want to use DBI? if your tables have same structure. I suggest
doing dump/export (depending on the database) and then import. Look for
utilities that came with your database.
if your tables are do not have same structure then look at the bind_param
methods. I suppose you can construct SQL statement dynamically based on desc
statement. Also not that its any of my business but having 150 column table
sounds very strange.
Anton
> -----Original Message-----
> From: Krung Saengpole [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 28, 2001 10:24 PM
> To: [EMAIL PROTECTED]
> Subject: Copy records from other database.
>
> Hi all,
>
> I want to transfer record from one table in first database to another
> table in second database. Can I use DBI to do it w/o INSERT... statement?
> Because of many fields of my table (around 150 fields), or can use INSERT
> statement easily with some method?
>
> Any helps would be gracefully thank.
>
> Krung
