Hello,

I've got a problem with timestamp fields that default to CURRENT_TIMESTAMP.
If I add data to the table using the "Table Data" tab, the timestamp field in the new row is displayed as filled with the word CURRENT_TIMESTAMP. When saving this record, it seems that SQLyog does fill the field with 0000-00-00 00:00:00 so that mySQL does not record the timestamp but 0000-00-00 00:00:00.

EDIT:
SQLyog creates an INSERT INTO ... (`created`) values (`CURRENT_TIMESTAMP`) instruction. This certainly won't work...

This is a known issue. More info at: http://www.webyog.com/forums/index.php?sho..._timestamp'

We plan to fix this issue in one of the future versions of SQLyog.

What you can do is to work from the RESULT pane. When you SELECT data then don't select the timestamp field!