Bicolano Express by Ryan Yonzon

…spitting out some few regular expressions

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About
  • Contact
  • Portfolio
  • Resume

Tag Archives: Database

Auto-update timestamp field

Posted on August 13, 2008 by Ryan
Reply

I keep on forgetting this SQL query. So I decided to put it here as a reference:

CREATE TABLE testtbl (
   id int AUTO_INCREMENT,
   created_on TIMESTAMP DEFAULT 0,
   updated_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
                    UPDATE CURRENT_TIMESTAMP,
   first_name varchar(25),
   last_name varchar(25),
   primary key(id)
);
Posted in Database, How-To | Tagged Database, How-To, MySQL | Leave a reply

Archives

  • July 2010
  • March 2010
  • December 2009
  • September 2009
  • August 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • August 2008
  • May 2008
  • April 2008
  • November 2007
  • October 2006
  • September 2006

Meta

  • Log in
Proudly powered by WordPress