CREATE TABLE `money` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `nickname` varchar(30) NOT NULL DEFAULT ‘‘ COMMENT ‘微信昵称‘,
  `headimgurl` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT ‘‘ COMMENT ‘微信头像地址‘,
  `money` decimal(10,2) NOT NULL DEFAULT ‘0.00‘ COMMENT ‘金额‘,
  `create_time` int(11) DEFAULT NULL COMMENT ‘创建时间‘,
  PRIMARY KEY (`id`)
  
)COMMENT=‘‘;

SELECT round(rand()*270000);

SELECT   FROM_UNIXTIME( (SELECT round(rand()*10) + 11), ‘%Y-%m-%d %H:%i:%s‘ )

UPDATE money set create_time = (SELECT round(rand()*10) + 11)
where 
id >= ‘1‘
and id <= ‘10‘