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

Forums | Webyog

Tools to manage and monitor MySQL databases

On Update Column For Table Creation , Altering

This topic is empty.

Viewing 1 reply thread

Author

Posts
- April 1, 2011 at 9:30 am #32106
  
  peterlaursen
  Participant
  
  Please read this FAQ:
  
  http://www.webyog.com/faq/content/8/159/en/how-do-i-define-timestamp-properties-with-sqlyog.html
  
  The first “TIMESTAMP NOT NULL” in a table is automatically becoming “”TIMESTAMP NOT NULL DEFAULT CURENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”. This is like this in MySQL since version 4.1 for compliance with earlier versions. So what you need to do is smply the check the NOT NULL checkbox and *nothing more* (ie. do not set a default explicitly)
- April 1, 2011 at 9:51 am #32107
  
  Mirel Stoica
  Member
  
  it's working thanks
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.