1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | INSERT INTO `parent` (`data1`) VALUES (@p0); SELECT `no` FROM `parent` WHERE ROW_COUNT() = 1 AND `no` = LAST_INSERT_ID(); -- 丟進資料庫執行 INSERT INTO `sub` (`data1`) VALUES (@p1); SELECT `id` FROM `at_item_sub_item` WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID(); INSERT INTO `sub` (`data1`) VALUES (@p2); SELECT `id` FROM `at_item_sub_item` WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID(); -- 有幾個子表項目就會有幾組,全部會一起丟進去資料庫執行 |
Direct link: https://paste.plurk.com/show/8mSG3dA1wH3c1AbPcOJu