dongoewang commented on issue #30600:
URL: 
https://github.com/apache/shardingsphere/issues/30600#issuecomment-2017304437

   > @dongoewang Please confirm if your SQL is correct. In MySQL, the correct 
syntax is:
   > 
   > ```sql
   > update kq_attendance_daily
   > SET attendance_plan_id = ?,
   > plan_type = ?
   > where id = ?
   > and attendance_date = ?
   > ```
   > 
   > Instead of
   > 
   > ```sql
   > update kq_attendance_daily
   > SET attendance_plan_id = ?,
   > plan_type = ?,
   > where id = ?
   > and attendance_date = ?
   > ```
   
   sorry,TherChenYang,you are right。that's my fault。
   because orginal sql is very long,i cutted some unimportant inforamtion,but 
unnecesarry comma has been left。
   


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to