Bug #31684 update table from MS ACCESS table to mysql table using crystal report
Submitted: 18 Oct 2007 1:47 Modified: 18 Oct 2007 2:19
Reporter: s w Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:Mysql client version 5.1.11 OS:Microsoft Windows (xp)
Assigned to: CPU Architecture:Any

[18 Oct 2007 1:47] s w
Description:
hi there
i have a problem with mysql table which cannot used in crystal report. i'm using Windows XP sp1 crystal report 9. when i want to update ACCESS table with mysql table there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.

How to repeat:
hi there
i have a problem with mysql table which cannot used in crystal report. i'm using Windows XP sp1 crystal report 9. when i want to update ACCESS table with mysql table there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.

Suggested fix:
give me solution for the process update table can work successfully
[18 Oct 2007 2:19] Jim Winstead
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

This was a repeat of Bug #31682.