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

timestamp function

forums › forums › SQLyog › SQLyog Comments › timestamp function

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 6, 2003 at 7:12 am #15014
      Shadow
      Member
      Quote:
      The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically.

      The solution is also provided in the MySql manual:

      Quote:
      TIMESTAMP columns other than the first may also be set to the current date and time. Just set the column to NULL or to NOW().

      I suggest to use NOW(), though…

    • October 6, 2003 at 9:31 am #15015
      Ritesh
      Member

      The above function is not possible with SQLyog's Insert/Update window as it updates each and every column for every update statement. Therefore, the automatic generation of TIMESTAMP from MySQL is not possible.

      Updation of changed columns is planned for SQLyog Max

      HTH

    • October 6, 2003 at 10:06 am #15016
      Shadow
      Member

      Or you could instruct the users to set the value of the second timestamp column to NULL. BTW, I don't think it is a good idea to use SQLyog as a data-entry tool…

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