mysql_connect("localhost "," user "," pwd ");
mysql_select_db('testdata ')?還是?死掉?(MySQL _ error());
$sql?=?“創造?程序?tb_neaten?(在?rec?int,in?爸?varchar(15),在?qy?十進制(10,2),in?ar?varchar(6))
開始
更新?test1?設置?數量=數量-qy?在哪裏?recordnum = rec
插入?變成?test2?設置?bname=pa,area=ar,qty=qy,date=date_format(now(),' %Y%m%d '),time=date_format(now(),' % Y % m % d ');
結束;";
mysql_query($sql)?還是?死掉?(MySQL _ error());
如果存儲過程包含捕獲選擇結果的語句,則需要在mysql_connect中調整參數。
mysql_connect("localhost "," user "," password ",1,131072)?
執行時,直接運行。
MySQL _ query(TB _ neaten(va 1,va2,va3,va4));