ecmall发布商品全流程sql语句

最新推荐文章于 2021-02-01 02:46:15 发布

ibmfashion

最新推荐文章于 2021-02-01 02:46:15 发布

阅读量1.2k

点赞数

分类专栏： php基础 ecmall

本文链接：https://blog.csdn.net/ibmfahsion/article/details/12878361

版权

php基础同时被 2 个专栏收录

120 篇文章 0 订阅

订阅专栏

ecmall

10 篇文章 0 订阅

订阅专栏

4 Query INSERT INTO ecm_uploaded_file(store_id,file_type,file_size,file_name,file_path,belong,item_id,add_time) VALUES('4986','image/jpeg','60912','2.jpg','data/files/store_4986/goods_135/201310191542155858.jpg','2','0','1382197335')
4 Query INSERT INTO ecm_goods_image(goods_id,image_url,thumbnail,sort_order,file_id) VALUES('0','data/files/store_4986/goods_135/201310191542155858.jpg','data/files/store_4986/goods_135/small_201310191542155858.jpg','255','93')
9 Query INSERT INTO ecm_goods(mk_price,goods_name,description,cate_id,cate_name,brand,if_show,last_update,recommended,tags,spec_qty,type,closed,add_time,store_id,cate_id_1,cate_id_2,cate_id_3,cate_id_4) VALUES('85','包邮13韩版partysu秋季新款女装拼色露肩镂空麻花性感针织衫毛衣','des','1210','女装/女士精品时尚淘宝女装','','1','1382197413','1','','0','material','0','1382197413','4986','21','1210','0','0')
9 Query INSERT INTO ecm_goods_statistics(goods_id) VALUES('257072')
9 Query INSERT INTO ecm_goods_spec(price,stock,sku,spec_id,goods_id) VALUES('65','0','','','257072')