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


   > @zosimer Hi, this error is reported because member is a keyword in mysql. 
You can rewrite it 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`;
   > ```
   
   But I didn't report this error in mysql5.7. I have been running this project 
for three years and won't change this word


----------------------------------------------------------------
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:
[email protected]


Reply via email to