dotku/tpshop mysql.md

## tpshop mysql.md

      
    Raw
  

              tpshop mysql.md
            
          
    相册处理

比如有这些 URL
/public/upload/goods/2017/08-15/1628/main/1.jpg
/public/upload/goods/2017/08-15/1628/main/2.jpg
/public/upload/goods/2017/08-15/1628/main/3.jpg
/public/upload/goods/2017/08-15/1628/main/4.jpg
/public/upload/goods/2017/08-15/1628/main/5.jpg
/public/upload/goods/2017/08-15/1628/main/6.jpg

倒入数据库
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/1.jpg', '0');
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/2.jpg', '0');
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/3.jpg', '0');
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/4.jpg', '0');
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/5.jpg', '0');
INSERT INTO `tpshop_2`.`tp_goods_images` (`img_id`, `goods_id`, `image_url`, `is_trash`) VALUES (NULL, '1628', '/public/upload/goods/2017/08-15/1/main/6.jpg', '0');