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

On Update Current Timestamp

forums › forums › SQLyog › Using SQLyog › On Update Current Timestamp

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 15, 2009 at 3:03 pm #29115
      peterlaursen
      Participant

      “According to this FAQ I can do that by selecting CURRENT_TIMESTAMP and NOT NULL”

      NOPE! There is no option to 'select CURRENT_TIMESTAMP'. Do you mean you enter this in default coloumn?

      Please read the FAQ again! You shall ONLY check 'NOT NULL'. Do not enter any default at all and the server will make it like this (because that is default in MySQL from 4.1 for the first NOT NULL timestamp of a table)

      Code:
      `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

      [attachment=1200:create.jpg]

      [attachment=1201:result.jpg]

    • June 16, 2009 at 3:39 pm #29116
      andrewteg
      Participant

      Thanks! You're absolutely right and apparently I need to learn how to read 😮

      It is working exactly as the FAQ claims. Thanks again.

    • June 16, 2009 at 3:55 pm #29117
      peterlaursen
      Participant

      No problem .. I give training courses in reading at 400$ per hour!

      Jokes apart: this is server behaviour: the first NOT NULL timestamp of a table will become NOT NULL CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP unless otherwise specified. As the FAQ tells we *could* add an ON UPDATE column to CREATE/ALTER TABLE grid. But as timestamps is the only data type where it applies currently, we have decided not to do now. Should the ON UPDATE option some day be added to more data types or should the MySQL timestamp implementation change we will do when we (or users) find it required.

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