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

Forums | Webyog

Tools to manage and monitor MySQL databases

How Do You Use A Mysql Function As A Default?

This topic is empty.

Viewing 4 reply threads

Author

Posts
- October 24, 2007 at 11:02 pm #10601
  
  JimZ
  Member
  
  Is there some special syntax or other trick?
- October 25, 2007 at 12:09 am #25186
  
  JimZ
  Member
  
  Ok, I found the answer… I guess you _can't_ use a MySQL function within a default, with the exception of using CURRENT_TIMESTAMP for a timestamp field.
- October 25, 2007 at 9:25 am #25187
  
  peterlaursen
  Participant
  
  Please read:
  
  http://webyog.com/faq/content/8/99/en/does…l-keywords.html
  
  http://webyog.com/faq/content/8/116/en/can…sult-panes.html
- October 25, 2007 at 5:28 pm #25188
  
  JimZ
  Member
  
  peterlaursen wrote on Oct 25 2007, 03:25 AM:
  
  Please read:
  
  http://webyog.com/faq/content/8/99/en/does…l-keywords.html
  
  http://webyog.com/faq/content/8/116/en/can…sult-panes.html
  
  That says nothing about using MySQL functions in a column default. It's a MySQL limitation, so there's no way that SQLYog can get around it. Thanks anyway.
- October 26, 2007 at 11:40 am #25189
  
  peterlaursen
  Participant
  
  I think it does!
  
  the first link:
  
  “This also applies to the DEFAULT value settings of the CREATE TABLE and ALTER TABLE panes and the MAPPING option of the Migration Wizard when using the three of the above KEYWORDS that may be used as a column DEFAULTs (they are NULL, CURRENT_TIMESTAMP and localtimestamp). “
  
  so the KEYWORDS NULL, CURRENT_TIMESTAMP and localtimestamp can be useed for column defaults. Functions cannot – except for now() that is internally represented as a synonym of CURRENT_TIMESTAMP.
Author

Posts

Viewing 4 reply threads

You must be logged in to reply to this topic.