Hi Tim,
I got a query for u.... Is it possible to source a
sql file through DBI in perl? If yes
How? I need this to automated my scripts for a long run
process.... I would be thank full if i get my
result ASAP...
Hi Tim,
FYI, My Datadase is MySql... and i want to execute this sql
statement "SOURCE
/home/sathish/test.sql" query via DBI... is it possible???? and
also is it possible to set a delimiter
via DBI for mysql database????
I think that the only way to do it with DBI is to read the sql file
and split it into its component sql queries (either via regex or
something like SQL::Statement), then execute each one of them
independently.
But there's a much easier way:
`cat file1.sql file2.sql | mysql -u USERNAME -p`
