[請益] mysql_query一次丟出數筆資料
若我有三句SQL語法想同時餵給資料庫
UPDATE `s`.`a` SET `sel` = '0' WHERE `a`.`number` = '94';
UPDATE `s`.`a` SET `sel` = '1' WHERE `a`.`pic` LIKE '126.jpg';
UPDATE `s`.`m` SET `img` = '126.jpg' WHERE `m`.`number` = 94;
這三句分別在兩個不同的資料表運行
若直接貼在MYSQL中可以正常運行(一次全貼上)
但是用mysql_query就不能一次餵三句給資料庫
是mysql_query不支援多語句嗎
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 60.250.91.223
→
02/09 20:07, , 1F
02/09 20:07, 1F
→
02/09 20:07, , 2F
02/09 20:07, 2F
推
02/09 20:46, , 3F
02/09 20:46, 3F
→
02/09 20:46, , 4F
02/09 20:46, 4F
→
02/09 20:50, , 5F
02/09 20:50, 5F
→
02/09 20:57, , 6F
02/09 20:57, 6F
→
02/09 21:59, , 7F
02/09 21:59, 7F
推
02/09 22:17, , 8F
02/09 22:17, 8F
→
02/09 22:38, , 9F
02/09 22:38, 9F
推
02/10 00:19, , 10F
02/10 00:19, 10F
推
02/10 00:41, , 11F
02/10 00:41, 11F
→
02/10 00:43, , 12F
02/10 00:43, 12F
推
02/10 02:50, , 13F
02/10 02:50, 13F
推
02/10 10:15, , 14F
02/10 10:15, 14F
→
02/10 10:17, , 15F
02/10 10:17, 15F
→
02/10 10:18, , 16F
02/10 10:18, 16F
→
02/10 10:18, , 17F
02/10 10:18, 17F
推
02/10 12:34, , 18F
02/10 12:34, 18F
→
02/10 12:35, , 19F
02/10 12:35, 19F
→
02/10 12:35, , 20F
02/10 12:35, 20F
→
02/10 12:36, , 21F
02/10 12:36, 21F
推
02/10 12:39, , 22F
02/10 12:39, 22F
推
02/10 12:48, , 23F
02/10 12:48, 23F
→
02/10 12:49, , 24F
02/10 12:49, 24F
→
02/10 12:50, , 25F
02/10 12:50, 25F
→
02/10 12:50, , 26F
02/10 12:50, 26F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章