Re: excuting several sql statements in one time
| From: | _lallous | Date: | Thu, 20 Sep 2001 09:58:31 +0000 |
| Subject: | Re: excuting several sql statements in one time | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67959@lists.php.net to get a copy of this message | ||
No you can't! I wrote a simple routine for the task!
you might want to view it from:
http://www.kameelah.org/eassoft/php_files/sql2php.php.txt
just take the parse_sql_stream($all) which returns an array that have all
the statments to be passed to mysql_query()
this script is usefull when you have a huge .SQL file that you want to
execute from PHP code.
"VM ÁÖ¿N" <seojuyung@hotmail.com> wrote in message
news:F152pgTFur2iz2Mb1s700003145@hotmail.com...
> Hello
>
> I want to know how to implement these several sql statements in one time.
>
> For example, I have 2 sql statements like :
>
> INSERT INTO com VALUES ('pentium');
> INSERT INTO com VALUES ('amd');
>
> Then, I want to excute these 2 sql statements in one time with PHP.
>
> I tried to implement like this :
>
> $query = "
> INSERT INTO com VALUES ('pentium');
> INSERT INTO com VALUES ('amd');
> ";
> mysql_query($query, $dbconnect);
>
> But as you know, it didn't work.
>
> Does any one know how to run this job?
>
> _________________________________________________________________
> MSN Explorer°¡ ÀÖÀ¸¸é Hotmail »ç¿ëÀÌ ÈξÀ Æí¸®ÇØ Áý´Ï´Ù. Áö±Ý
> http://explorer.msn.co.kr/ ¿¡¼ ¹«·á·Î
> ´Ù¿î·ÎµåÇϼ¼¿ä.
>