From: Martijn Tonies
Date: April 10 2006 9:51am
Subject: Re: timestamp & not null
List-Archive: http://lists.mysql.com/mysql/196688
Message-Id: <01dd01c65c84$663a67e0$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi,

> I created a table and, into it, a timestamp field:
> ... EXPIRES TIMESTAMP NOT NULL, ...
>
> When I issue the command "describe" it shows the field "expires" allows
nulls and defaults to CURRENT_TIMESTAMP. Also, each time I update
> a field other than "expires" in this table, "expires" gets updated to the
current timestamp.
>
> Does anybody know how can I make a timestamp field be "not null"?
> Lots of thanks to you all.

If you want to store date/time values, do not use the TIMESTAMP
datatype.

What is it that you're trying to do?

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com