数据库5.7.17 插入语句报错1055,百度许久都是统一答案!并没有解决问题
来源:2-2 用户类API-实现用户注册API、登录API

慕标3075454
2017-08-07
数据库信息:
版本:5.7.17
数据表信息:
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
`desc` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
数据库写入语句:
insert into `users` (`id`,`name`,`email`,`password`,`remember_token`) VALUE (null,12,null,12,null)
报错信息:
[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 sql_mode=only_full_group_by
2回答
-
数据库写入语句:
insert into `users` (`id`,`name`,`email`,`password`,`remember_token`) VALUE (null,12,null,12,null)
sql语句错了 是values 试试吧
012017-08-09 -
慕少3988074
2017-08-08
我的插入语句这么写的,把 表名后面括号里的字段名的单引号都去掉了,我这就插入成功了,不知道你和我是不是一样的问题
10
相似问题