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=小程序用户表;
#查询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=小程序用户表;