php mysqli_multi_query 執行多筆 sql 指令 -- update 多筆用
在 update 不同值時, mysqli_query 只能一筆一筆更新,時間效率都很差,上網找的方法是產生一個更新資料暫存表,再用唯一值一次更新.
經過重覆測試,指令如下:
$sql1 = "CREATE TABLE IF NOT EXISTS `std_pnum` ( //產生暫存,最後沒有刪除,想說都要用
`stdno` varchar(10) NOT NULL,
`subjno` text NOT NULL,
`class` varchar(6) DEFAULT NULL,
`grade` varchar(8) DEFAULT NULL,
`seme` varchar(6) DEFAULT NULL,
`pnum` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$sql1 .= "delete from std_pnum ;"; //一開始先清空 tmp表
$sql1 .= "set @count := $bnum ; "; //設定開始更新值,由 php 代入
,宣告變數要用 set 或 select ,不可用 declare (在有 begin - end 內才可以用,一開始用 Declare 在這裡卡好久)
//用現有資料,利用 stdno 當唯一值,相同同編號,因為 @count := @count + 1 會跟來源變動,所以用子查詢我方式,將來源先轉成單純的唯一值排序,這樣@count 才會正常累加
$sql2 = "insert into std_pnum
select c.stdno,c.subjno,c.class,c.grade,c.seme, @count := @count + 1 from
(select a.* from pig_reopen_std a LEFT JOIN student b ON a.stdno = b.stdno
WHERE a.indate >= '{$config['okdate']}' AND
a.syear={$config['syear']} AND ((a.delete_yn<>'Y') Or (a.delete_yn
Is Null)) AND a.pnum <= 0
group by a.stdno
ORDER BY b.classno,b.seat,a.stdno,a.subjno,a.class,a.grade,a.seme) c ; ";
//直接用產生的暫存表更新
$sql3 = "update pig_reopen_std a ,std_pnum b set a.pnum=b.pnum where a.stdno = b.stdno ;";
$sql = $sql1 . $sql2 . $sql3 ;
if (mysqli_multi_query($link, $sql)) { //執行sql
do {
mysqli_free_result($result);
if (mysqli_more_results($link))
{
$up_num = mysqli_affected_rows ( $link ); //取得最後更新筆數
}
} while (mysqli_next_result($link));
}
本來更新350筆要14秒,現在馬上完成,顯示0秒
迴響
php mysqli_multi_query 執行多筆 sql 指令 -- update 多筆用 | 豬窩
Its not mmy first time to payy a quck vksit thiis website, i aam browsing thus site dailly
annd takke pleasanht facts fromm hwre everyday.
php mysqli_multi_query 執行多筆 sql 指令 -- update 多筆用 | 豬窩
Croc lesbianVintage baseball wisconsinYoung gayy sesPerez hilton sucksMony talks frede pornPehis achine spencer burdockPornstar acad mie torrentSexx videos wiith pantiesPussy getting things shoved inn it19th century
gayy erotic artSemale chloeFilipina girls iin bikinisMidgit nude picture womanThe avatar carttoon xxx and hentaiEx girofriend sex
videosKeri russell bikini photoBorn too late vintageGerman stydy hheart health men breastsWhyy do teeens commit crimesStraight
guys fucxking eachotherYoung asian bbig dickAsian irr camFree adult
couples dvdHooters girls iin pantyhoseRaven riley fuck
forumTiit bangung wifeGoodzilla ddomination cheaqt codeEmmma
starr spank wireAdult channels on dishtv indiaRude com bbbw facesittingLesbian tittty fuckersSleeping ebony sexEscorrt accompagnatrice romja
https://bit.ly/31erYyH Brittney anal sexCelebs
fucked hardVivin von queef nude https://bit.ly/35kbMxk Wajfs nudeCasee strudies
of pornographyHanna's haven teen challenge https://tinyurl.com/yzab82q9 Ratee your breastBug tirs top listAdult dating http https://bit.ly/31y8bxa Flur creampie gangbangedSwinging wifes in fargoWach hziry women https://bit.ly/3vgDDda Blog vixeo pornCost foor breastPlease fuc my ife traiper https://bit.ly/3zzT3f7 Ashhley escort ohare
chicagoBaby pee iis tooo yellowEnjoying sex with housemaid stoory https://bit.ly/3nDAYGR Sexy sluttty teeniesGranny and daughter sexThe naked luncch
film https://bit.ly/3vvq5dQ Iowa same seex marriage lawsPeniss napkin trickFreee meet and fucdk accounts https://bit.ly/3jDFLc3 Porrn star teen brunetteSerosanguinous vaginal dischargeSex offender laws for tennessee https://bit.ly/36hYXEm Burger king
franchise sexual harassment caseFreeforever pornChloe sevigny sucking cochk video https://bit.ly/33xs0Dl How to drraw a pussyBreast expressingLaura j
orgasm https://cutt.ly/0US5XJ2 Youtube style adult
websiteGayy melbourne meeting placesGay realtor st pestersburg https://bit.ly/2SHrcsz Hosea chanchez naaked photos leakedFreee fist fucking
pussy videosRussian teden porn t p https://bit.ly/34Nsvsy Shalloww penetration sexSabrin aui gangbangWifes outdoor nue pics https://bit.ly/33W0qj9 Grannes giving blow jobsMom annd dad xxxKorean women with big tits https://bit.ly/2SkT0mw Naked sexy
nudee chicksEngagement ring box and asianMeg white porn free https://bit.ly/3qlalJ8 Exoitic blowjobsNaked
iss grossSex dopl kobe https://bit.ly/3xMKagE Vivic foxx ssex tapeMichiko kakutani sex and
the cityBigtube porn july 2010 https://bit.ly/34JaFGR Mrks on dildoCrazydumper facialAdjlt acttress modelingg https://bit.ly/2HrHnVe Fuckk van shoes them skateboardFrree sex movie indianFree amaguer videos nudde real
https://bit.ly/2SSszFj Europeran escort serviceGena llee nnolin nde meta cafeMonster oof facials https://tinyurl.com/2nsenlfz Space marine fuckAssian elephant tattoosTendonitis thumb https://cutt.ly/1UJ1Tr0 Deep
throats picsTvt reppair vaginal bladderNaked cross dresser porn https://bit.ly/3ytcHbm Evisu bowlkng geishasBarrb screamed fuck mme harderCelebrity hollywood
scene seex https://bit.ly/37meBAk Argentinian giirls nakedGirps modeling lingerieFatt and skinny lesbian porn https://tinyurl.com/yfbp5j63 Sex poen porr teenKate middleton nude fakesInteracial cock loveer https://bit.ly/3Dhqx2u Same sex sezual violenceTeenn
spendingsGay throat gagging videos https://tinyurl.com/ygywe9ue Youtube thee naked brotherCockk cum parrty shotDick milham pa https://bit.ly/3BvW2It P53 ene annd breast
cancerMen naked inn tthe gymAdult stores in nashua nh https://bit.ly/2TyeM70 Hoow to suck
thhe best penisSex odel videoFucking my aunt andd her fried https://tinyurl.com/yhcg87vp Download gay porn dvds ffor freeBlack cock interracial pussy whiteFreee horny teens vids https://bit.ly/3lEHXxxp Asian amatur sex tapesJapanese daughter cunnilingus gradesEaating my girlfriend's
pussy https://cutt.ly/BY4CQaG Lesbians taking itt in the mouthTits in shirtsEscort cornwall uuk https://cutt.ly/tUMycne Homer and marge having sex with bartJackson adult classesSexxy female muscle ics https://bit.ly/3GdYuTg Free hardcore aanime picAnimated birthday card e free
sexyExtrene tit bondage https://cutt.ly/2Y20ATd Thhe priice ffor breaast implantsAmateur cracksmanParaded naked througfh thee street https://bit.ly/3j5tRrd Free
unusua amateurFree black porn noo creditFree drunk gangbang
sexx mpegs https://bit.ly/3oGmsB2 Retro boys gay youngOnline sex tv moviesBest liquor for sexx https://tinyurl.com/byjbv4sj Jillian posing nudeSllut traijning floridaAdult soccer league appleeton becdky https://bit.ly/3iSuSie Latina girl
sucking hge cockStrip tenie 2009 jelsoft enterprises ltdFree carmen coks videos https://bit.ly/3G6sLUD Erotic mother videosLyrics tto lets
talk about sexGirls ffingering bohs porn https://bit.ly/3hF3nuc Age
of empires 3 the asian dynastysAdult dasnce classes atlantaCums advanced guestbook 2.4.2 https://bit.ly/3k50xyE Chumbawammba pissing the night awayOldster pornWatch julie
bowen nide https://bit.ly/3uS4RpC Sexy lagina lesbians doing 69Tiit porn galleriesWannt
to see free porn https://tinyurl.com/yekq4dpe Free pussy on the
beach picturesState of ohioo registered sex offendersBbbw maturee porfn pics
https://bit.ly/3jznIAQ Leonor vaginaSikis ssex porn ideo tubeFucking
scens https://tinyurl.com/2gyfjgjo Frree anal gape videosBeest
ten sexFucking gardenwr https://cutt.ly/TcCf7Qc Free nude pirn oof stephanie
lyBbww strapon pornThe number 3 sucks https://tinyurl.com/2m9sychl Seexy
phone vidsAdujlt diaper disposal systemDotor exaam breast https://bit.ly/3ddGdIO National breast screening serviceMmmf thfeesome positionsYoung pitite teensIll fuxk and fuck until i dieMature
video pornScheisdse sieht die sexy aus lyricsNikk webster nudeChane1 pantyhoseGay
single muscle menNo membership family pornVaginal toys videoClaudia marie
first analNew malden escortsFree bisexull pon clipsComppletely naked guysVideos pictures sexx ball positionsAdulkt eyye candyChesssie moore interracial
videoLive video grandma suxks cockYasmine bleeth titsYoung hardcore babesGirlls sucking monster dickFlm sexHow ddo humahs hopd pee for long amjounts of timeBrreast lummps andd lymph nodesCrazy girl figths get nakedSlut wive imppreg sex storiesOld ccum sexPaimful
deep penetrationTerrible sex pornSexy boob dancing videoBoook brerast cancer decision informmed now make
needMareied women looking for men for sexFreee videro mother son fuckFucken sexy womanSexul satute of limitationsSelena slice asss picsSims 2 petss
nude patchPre teen super modelChugorth pornRaleigh nc escortsAlice eve sex videoFamous naked
women nudeFree sex sorie postGranmny bbw facesittingGirlos gettin spanked and fuckedPrcum does not contain spermVip glamour babrs nudeErotic
seex piictures of womenReal blowjob feee videos