[GitHub] [shardingsphere] strongduanmu commented on issue #8623: no viable alternative at input

[GitBox <gi...@apache.org>]

strongduanmu commented on issue #8623:
URL: https://github.com/apache/shardingsphere/issues/8623#issuecomment-747205442


   @zosimer Hi, this error is reported because member is a keyword in mysql. You can rewrite it in a way like this:
   
   ```sql
   select member_id,mobile,nickname,name,icard,photo,sex,birthday,platform,province,city,distri
   ct,college_id,college_name,member_state,member_type,invite_code,rank_points,pay_points,money,frozen_money,gold,frozen_gold,login_ip,log
   in_date,login_flag,sign,is_special,is_service,remarks,del_flag,create_by,create_date,update_by,update_date from `member`;
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org