解决SELECT list is not in GROUP BY clause and contains nonaggregated column 'novle'
使用MySQL,创建视图,SQL语句如下SELECT `n`.`id` AS `novelID`, `n`.`name` AS `novelName`, `n`.`info` AS `introduction`, group_concat(`t`.`name` SEPARATOR ',') AS `novelType`, `n`.`author` AS ...
原创
2019-01-21 14:29:19 ·
21222 阅读 ·
3 评论