or execute a shell command
$ret = `mysql -u[user] -p[password] -h[host] [db_name] < file.sql`;
glumtail wrote:
I think it's better to split the SQL into pieces
line 1: create table ....
line 2: insert into .....
$sql = 'create table....'
$sql = 'insert into ...'
2005/7/13, Shaw, Chris - Accenture <cshaw@xxxxxxxxxx>:
Can you use mysqli_multi_query for mysql in php5?
hth
-----Original Message-----
From: babu [mailto:garavindbabu@xxxxxxxxxxx]
Sent: 13 July 2005 16:39
To: php-general@xxxxxxxxxxxxx
Subject: How to run .sql files using php
Hi ,
i have a set of queries which i have placed them in one .sql file.i want
to
run this file using php's mssql and oracle(oci) functions.
any idea pls.
thanks.
babu
---------------------------------
How much free photo storage do you get? Store your holiday snaps for FREE
with Yahoo! Photos. Get Yahoo! Photos
************************
This message has been delivered to the Internet by the Revenue Internet
e-mail service
*************************
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
