uniapp 如何配置MySQL_uniapp后台api设计(微信user表)

#查询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) default null comment '省份',

`city` varchar(100) default null comment '城市',

`language` varchar(100) default null comment '语种',

`create_time` datetime default null comment '创建/注册时间',

`update_time` datetime default null comment '更新时间',

`mobile` varchar(50) default null comment '手机号码',

primary key (`id`)

) engine=innodb default charset=utf8 comment='小程序用户表';