#查询mysql版本号 sql_mode方式
select version(), @@sql_mode;
#[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
CREATE TABLE `lev_wx_user` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`openid` varchar(28) DEFAULT NULL COMMENT '小程序用户的openid',
`nickname` varchar(100) DEFAULT NULL COMMENT '用户昵称',
`avatarurl` varchar(100) DEFAULT NULL COMMENT '用户头像',
`gender` tinyint(1) DEFAULT NULL COMMENT '性别 0-男、1-女',
`country` varchar(100) DEFAULT NULL COMMENT '所在国家',
`province` varchar(100)