SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-10-2008, 02:03 PM
| ||||
| ||||
 Timestamp and the On Update Current_Timestamp clause 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      |
|
05-10-2008, 02:03 PM
| |||
| |||
| 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, 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 > > |
|
05-10-2008, 02:03 PM
| ||||
| ||||
| 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.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com |
 |
« Error reading packet from server: Out of memory (Needed 6560 bytes)( server_errno=5)
|
Block size of filesystem »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 05:27 AM.
