From: Ben Clewett
Date: May 9 2008 2:33pm
Subject: Re: Timestamp and the On Update Current_Timestamp clause
List-Archive: http://lists.mysql.com/mysql/212716
Message-Id: <482460B3.9080504@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

SHOW CREATE TABLE ...

Martijn Tonies wrote:
> Hi,
> 
> How does one know if ON UPDATE CURRENT_TIMESTAMP was specified when
> creating a column? How do I retrieve this bit of info from the metadata
> queries?
> (also MySQL 4.1)
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
>