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

Autodate

forums › forums › SQLyog › Using SQLyog › Autodate

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 8, 2004 at 10:46 pm #16512
      Shadow
      Member

      If you mean to have a column that is set to the current date when a record is inserted, then yes, this's what timestamp fields are for. If you mean to “log” the insertion date in any other table, then strictly speaking no, as MySql has no support for triggers as of now. Of course, you may still use transactions. You start a transaction, insert a record to a table, insert a current date to a second one, then commit. This method will never be that accurate like a trigger, but close enough.

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