Re: Timestamp and the On Update Current_Timestamp clause

Here is my test. Any way can retrieve the metadata. On Fri, May 9, 2008 at 10:45 PM, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > SHOW CREATE TABLE ... > > Yes, I thought so :-( > > > From a coding point of view, this requires parsing... > > Why isn't there anything in "show full columns". >

Re: Timestamp and the On Update Current_Timestamp clause

> SHOW CREATE TABLE ... Yes, I thought so :-( >From a coding point of view, this requires parsing... Why isn't there anything in "show full columns". Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upsce

Re: Timestamp and the On Update Current_Timestamp clause

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