Toad World® Forums

MySQL Attribute Comments with Equal Sign


#1

Hello TDM Community,

Using TDM3 for a MySQL 5 database. When I generate a DDL script for a table with comments, the modeler generates

comments = ‘This is a comment’

… which cause me to get the error…
#1064 - 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 '= ‘This is a comment’

If I remove the = signs and just use …

comments ‘This is a comment’

… I get no error.

Sorry, found this thread… http://modeling.inside.quest.com/thread.jspa?threadID=4944&tstart=0

Thanks,
Scott

Message was edited by: ECU_Scott