java-jsonlib

 

INSERT INTO `goods`
SELECT
  MD5(RAND()),
  `locale`,
  `category`,
  `name`,
  `pcode`,
  `image`,
  `intro`,
  `details`,
  `price`,
  `mprice`,
  `weight`,
  `inventory`,
  `invstatus`,
  `minbuy`,
  `hassold`,
  `ctime`,
  `utime`,
  `status`,
  `csort`,
  `keywords`,
  `aftersales`,
  `invoice`,
  `warranty`,
  `logistemp`,
  `manager`
FROM
  `e6mall`.`goods` ;

SELECT COUNT(id)FROM`goods`