|List:||General Discussion||« Previous MessageNext Message »|
|From:||Greg Whalin||Date:||June 9 2005 7:53pm|
|Subject:||Re: Seriously.. When are we going to get subqueries?!|
|View as plain text|
Jeff Smelser wrote: > On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote: > > >>Another limitation in MySQL is that you can only have one timestamp column >>with a default of CURRENT_TIMESTAMP. >> > > > How many friggin times do I have to say that this is not an issue with 4.1 and > above? Which, BTW, is production mysql.. > > Why do you keep bringing this up? > > Jeff Are you sure? I don't see that from http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html It seems that w/ > 4.1, you can specify any ONE timestamp col w/ default of CURRENT_TIMESTAMP. You are not limited to the 1st one, but still seems you are limited to a max of 1 timestamp. Or am I reading this wrong?