distinct:相当于去除重复行的作用,不是指写在哪个字段前面,哪个字段就不是重复的情况,但是必须跟在select后面,否则会出做
select distinct gtid, cookie from tablename;
错误示例:
select gtid, distinct cookie from tablename;
会出现如下错误情况
Error:line 1:13 cannot recognize input near 'distinct' 'cookie' ',' in selection target