Toad World® Forums

Enhancement & Problem on Generated SQL script for MySQL5


#1

Hi

I have created a table on Toad Data Modeller, I try to use the SQL script that generated by “DDL Script Generation function” to create the table and primary key. Unfortunately when I run the sql script on MySQL Query Browser It display an error message “Incorrect Table Definition; there can be only one auto column and it must be defined as a key”

I guess that problem occur is because the primary key is created after the creation of the table. Is there any way I can get around this problem if not I would be grateful if that problem can be solve in next beta.

Another thing I would like to mention is in MySQL only 1 column in a table can be use as auto-increment. Would it be possible to have little bit validation when you design/create the table in toad, if you detect there has anther field that has been set to auto-increment in the same table, it would notice the user.

Another feature I would like to add on Toad data modeller is, to allow user to change some settings on the database E.g. Collation, type …etc.
And also provides an option for the user which could allow whether they want the “DDL Script Generation function” to generate the Database script for them. E.g. Create Database script.

Please let me know if you want me to explain more.

Many thanks

Chi


#2

I am having the same issue. It would be really cool if we had the option to define the Primary Key Inline or if it would do it automatically if the priamry key attribute is set to AUTO_INCREMENT.

Any ideas on getting around this issue would be greatly appreciated.


#3

I think these problems were reported multiple times already.
There was some kind of MySQL hot fix for final 3.0 version.

http://modeling.inside.quest.com/thread.jspa?threadID=5069&tstart=0

I can’t validate the content of the hotfix, the quest page requires login.
(odd, login for a hotfix download?)


#4

Hello all,

To the ‘Autoincrement problem’:

Arki provided you with a hotfix for official TDM3 version.

Here’s a hotfix for TDM3 BETA 3.1.1.166:
http://modeling.inside.quest.com/entry.jspa?externalID=1254&categoryID=34

Please see my announcement at:
http://modeling.inside.quest.com/thread.jspa?threadID=4872&tstart=0

All hotfixes for BETA are available in the Library section at:
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=34

Chi, to your suggestions:

I would like to mention is in MySQL only 1 column in a table can be use as auto-increment. Would it be possible to have little bit validation when you design/create the table in toad, if you detect there has anther field that has been set to auto-increment in the same table, it would notice the user.

O.K. We will deal with it. CR # 39 203.

Another feature I would like to add on Toad data modeller is, to allow user to change some settings on the database E.g. Collation, type …etc. And also provides an option for the user which could allow whether they want the “DDL Script Generation function” to generate the Database script for them. E.g. Create Database script.

If you like to use e.g. CREATE DATABASE statement etc., you can write it to: Model menu | Model Properties | Before Script tab.

If you have any questions, please write us back. Thanks.

Regards,

Vladka + TDM Team