RE: datetime field question

2003-01-30 Thread Sherzod Ruzmetov
:is there a way to use the date part of a datetime field that :still uses the :index on the datetime field? i've tried a few different things :and it keeps :saying in the explain it says that its a possible_key, but :NULL for the key I'm not sure if this ignores the indexes

Re: datetime field as key

2002-12-23 Thread Michael She
Hi, you can use a DateTime field, but it is possible to get duplicate datetimes if you insert multiple queries fast enough. At 04:17 PM 12/23/2002 -0200, João Borsoi Soares wrote: I would like to use a datetime field as a key. I'm wondering if I will have any problems with key violation. I foun

Re: datetime field

2001-01-20 Thread Dan Nelson
In the last episode (Jan 21), Muhammad Farhan Ghazi said: > How much space is taken by the datetime field? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Storage_requirements > Is there any way that we can only store date or time in it? http://www.mysql.com/documenta