解决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 ·
21139 阅读 ·
3 评论