Open youngwang12138 opened 2 years ago
https://zhongyang.wang/post/1662306070/
表结构及插入数据 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 DROP TABLE IF EXISTS listings; CREATE TABLE listings ( store_id int(11) DEFAULT NULL, id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; LOCK TABLES listings WRITE; /!40000 ALTER TABLE listings DISABLE KEYS /; INSERT INTO listings (store_id, id, product_id) VALUES (3,1,1), (3,2,2), (3,3,1), (3,4,1), (3,5,2); /*!
listings
store_id
id
product_id
https://zhongyang.wang/post/1662306070/
表结构及插入数据 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 DROP TABLE IF EXISTS
listings
; CREATE TABLElistings
(store_id
int(11) DEFAULT NULL,id
int(11) NOT NULL AUTO_INCREMENT,product_id
int(11) DEFAULT NULL, PRIMARY KEY (id
) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; LOCK TABLESlistings
WRITE; /!40000 ALTER TABLElistings
DISABLE KEYS /; INSERT INTOlistings
(store_id
,id
,product_id
) VALUES (3,1,1), (3,2,2), (3,3,1), (3,4,1), (3,5,2); /*!