Re: excuting several sql statements in one time
| From: | mydata | Date: | Thu, 20 Sep 2001 09:50:42 +0000 |
| Subject: | Re: excuting several sql statements in one time | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67962@lists.php.net to get a copy of this message | ||
yes, it will not work,because mysql does not support it(the way you try to
use is 'procedure' called in MS SQL sever) , mysq developer said they will
accomplish in the further . you and I have to wait for it.
"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/ ¿¡¼ ¹«·á·Î
> ´Ù¿î·ÎµåÇϼ¼¿ä.
>