U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Creating a TIMESTAMP column in MySQL [message #32213]

Sun, 01 May 2011 16:46

bushman is currently offline

bushman
Messages: 134
Registered: February 2009

Experienced Member

Hi, all!

Is there any .sch file macro for CREATEing a column like
'`my_column_id` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP'
in a MySQL DB?

Is it what MySqlSchema.h macro TIMESTAMP(ts) does, i.e. creates a column that defaults to CURRENT_TIMESTAMP?

If so, could anyone give me an example on how to use it?

I've tried

TIME_ (MY_COLUMN_ID) TIMESTAMP("CURRENT_TIMESTAMP")

,
it compiled fine, but the resulting CREATE TABLE statement defaults column to NULL.

I've searched the documentation and this forum but couldn�t find anything.

Thank you all in advance!

Report message to a moderator

Send a private message to this user

[Message index]

		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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Apr 28 15:06:14 CEST 2024

Total time taken to generate the page: 0.06226 seconds