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

How Do You Set The Default Vale For A Date Field?

forums › forums › SQLyog › Using SQLyog › How Do You Set The Default Vale For A Date Field?

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 5, 2009 at 4:43 am #29419
      Manoj
      Member

      According to 10.1.4. Data Type Default Values no, you can't do that with date column.

      But you can do it with timestamp.

      create table test (

      id int,

      ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.