Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Small Point
Hi
How about this? – optimal datatype suggests Char for Datetime
last_modified | datetime NULL | CHAR(0)
Despite this – great software BTW.
Kind regards
Jon
1) SQLyog executes 'procedure analyse' (http://dev.mysql.com/doc/refman/5.1/en/procedure-analyse.html) . If you execute same from SQLyog editor (or command line or whatever) what do you get?
2) What is the server version? The question is in particular relevant because it is actually the server that 'recommends' and not SQLyog that 'invents'. And the 'server recommendations' may be better with recent than with old versions.
Hi Peter
Good grief, what service 🙂
Checking it – it seems it happens when there is no data in the column.
The server is 5.5.8.
Not your problem then … but a MySQL thing.