Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Bug With Timestamp Field Default Current_timestamp

This topic is empty.

Viewing 2 reply threads

Author

Posts
- November 3, 2005 at 6:20 pm #9341
  
  gosql
  Member
  
  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…
- November 3, 2005 at 7:10 pm #19685
  
  Ritesh
  Member
  
  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.
- November 3, 2005 at 10:57 pm #19686
  
  peterlaursen
  Participant
  
  What you can do is to work from the RESULT pane. When you SELECT data then don't select the timestamp field!
Author

Posts

Viewing 2 reply threads

You must be logged in to reply to this topic.