往多张表内插入数据
比如orders和orders_items表是有相关性的
INSERT INTO orders (customer_id, order_date, status)
VALUES (1, ‘2019-01-02’, 1)
INSERT INTO order_items
VALUE
(LAST_INSERT_ID(), 1, 1, 2.3),
(LAST_INSERT_ID(), 2, 1, 3.3)
(LAST_INSERT_ID(), 3, 1, 5.3)
若有收获，就点个赞吧
0 人点赞
