测试数据的mysql文件中,没有create table语句,直接导入会发生错误。
建议在mysql中添加创建表格部分。
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 数据库: `fecshop`
--
--
-- 转存表中的数据 `product_custom_option_qty`
--
INSERT INTO `product_custom_option_qty` (`id`, `product_id`, `custom_option_sku`, `qty`) VALUES
(10, '581c6833f656f2042f2f0b77', 'red-s-s2-s3', 99978),
(11, '581c6833f656f2042f2f0b77', 'red-m-s2-s3', 99997),
(12, '581c6833f656f2042f2f0b77', 'red-m-m2-s3', 99990),
(13, '581c6833f656f2042f2f0b77', 'red-m-m2-m3', 99874),
(14, '581c6833f656f2042f2f0b77', 'red-m-m2-l3', 100002),
(15, '581c6833f656f2042f2f0b77', 'red-m-l2-l3', 99998),
(16, '581c6833f656f2042f2f0b77', 'red-m-l2-s3', 99999),
(17, '581c6833f656f2042f2f0b77', 'red-m-l2-m3', 99999),
(18, '581c6833f656f2042f2f0b77', 'red-l-l2-m3', 99996),
(19, '581c6833f656f2042f2f0b77', 'red-l-m2-m3', 99999),
(20, '581c6833f656f2042f2f0b77', 'red-l-m2-l3', 99999),
(21, '581c6833f656f2042f2f0b77', 'black-s-s2-s3', 99998),
(22, '581c6833f656f2042f2f0b77', 'black-s-l2-s3', 99997),
(23, '581c6833f656f2042f2f0b77', 'black-s-xl2-s3', 99999),
(24, '581c6833f656f2042f2f0b77', 'black-s-s2-l3', 99999),