Toad World® Forums

MySQL 5.1 Timestamp data type NULL problem


#1

(TDM 3.4.14.6)

Hi,

I have Timestamp data types in my MySQL 5.1 data model, some are set as NOT NULL and others can be NULL.

When I create a new DDL script, MySQL automatically makes any Timestamp data type NOT NULL, unless explicitly specified as NULL in the create script.

Is there any way I can set this in TDM so that it creates my scripts with Timestamp data types as NULL explicitly where I do not check the NOT NULL checkbox?

Thank again for any help

Best Regards
Rudi


#2

Hi Rudi,

I sent you a solution via Email.

Regards,

Vaclav


#3

Hi Vaclav

I reveived your email and the solution works. I gather it will be available in the new version as well?

Thanks for all help.

Regards
Rudi


#4

Hi Rudi,

Yes, the solution will be in next major commercial version.

Regards,

Vaclav