增加用户

zangcf

INSERT INTO shopping_user (
`id` ,`addTime` ,`deleteStatus` ,`MSN` ,`QQ` ,`WW` ,`address` ,`availableBalance` ,
`birthday` ,`email` ,`freezeBlance` ,`gold` ,`integral` ,`lastLoginDate` ,`lastLoginIp` ,`loginCount` ,
`loginDate` ,`loginIp` ,`mobile` ,`password` ,`report` ,`sex` ,`status` ,`telephone` ,
`trueName` ,`userName` ,`userRole` ,`user_credit` ,`photo_id` ,`store_id` ,`qq_openid` ,`sina_openid` ,
`store_quick_menu` ,`parent_id` ,`years` ,`area_id` )
VALUES (
'32784', '2014-03-01 16:13:53.0', 0, null, null, null, null, null,
null, '55556@qq.com', null, '0', '0', null, null, '2',
'2014-03-02 15:05:45.0', '49.220.82.239', null, 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '0', null,
null, 'buy1', 'BUYER', '0', null, null, null, null,
null, null, '0', null);

INSERT INTO shopping_user (
`id` ,`addTime` ,`deleteStatus` ,`MSN` ,`QQ` ,`WW` ,`address` ,`availableBalance` ,
`birthday` ,`email` ,`freezeBlance` ,`gold` ,`integral` ,`lastLoginDate` ,`lastLoginIp` ,`loginCount` ,
`loginDate` ,`loginIp` ,`mobile` ,`password` ,`report` ,`sex` ,`status` ,`telephone` ,
`trueName` ,`userName` ,`userRole` ,`user_credit` ,`photo_id` ,`store_id` ,`qq_openid` ,`sina_openid` ,
`store_quick_menu` ,`parent_id` ,`years` ,`area_id` )
VALUES (
'32785', '2014-03-01 16:13:53.0', 0, null, null, null, null, null,
null, '55557@qq.com', null, '0', '0', null, null, '2',
'2014-03-02 15:05:45.0', '49.220.82.239', null, 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '0', null,
null, 'seller1', 'BUYER', '0', null, null, null, null,
null, null, '0', null);

关键，password是加密的
primary_key要注意不同