U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Creating a TIMESTAMP column in MySQL

Sun, 01 May 2011 18:23

bushman
Messages: 134
Registered: February 2009

Experienced Member

I figured out myself one way on how to do it:

COLUMN_("TIMESTAMP", Time, MY_COLUMN_ID, 0, 0)

The following column results from the code above:

MY_COLUMN_ID timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Now, how do I get rid of the 'ON UPDATE CURRENT_TIMESTAMP' part?

Many thanks!

		Creating a TIMESTAMP column in MySQL By: bushman on Sun, 01 May 2011 16:46
		Re: Creating a TIMESTAMP column in MySQL By: bushman on Sun, 01 May 2011 18:23
		Re: Creating a TIMESTAMP column in MySQL By: zsolt on Sun, 01 May 2011 20:08
		Re: Creating a TIMESTAMP column in MySQL By: bushman on Sun, 01 May 2011 22:00
		Re: Creating a TIMESTAMP column in MySQL By: zsolt on Mon, 02 May 2011 09:03
		Re: Creating a TIMESTAMP column in MySQL By: bushman on Mon, 02 May 2011 17:53
		Re: Creating a TIMESTAMP column in MySQL By: mirek on Wed, 04 May 2011 20:01

Previous Topic:	MySqlSession::GetTransactionLevel() implementation
Next Topic:	fetch not reading into struct

Goto Forum:

] [

]

Current Time: Mon May 13 15:59:08 CEST 2024

Total time taken to generate the page: 0.02611 seconds