#mysql

09 November 2007

Total 27 pages. You are browsing page 27/27.

First :: Prev :: [...] [23] [24] [25] [26] [27] :: Next :: Last

23:47 <****> of course you can - use a temporary table
23:52 <****> adaptr: hm.. just stumbled onto that you can do SELECT 'value',field1,field2
23:54 <****> why use select at all ? when you're just INSERTing rows ?
23:55 <****> what's the best/most efficient way to select rows based on a year in a timestamp column?
23:56 <****> YEAR(timestamp) = 2007; doesnt make use of indexing, does it?
23:57 <****> bleh BETWEEN lastyear and nextyear
23:57 <****> if you don't index the date, it will never be efficient, whatever you do
23:57 <****> Anybody know what would cause this error when I try to build myself without the client (./configure --without-client)? "make[2]: *** No rule to make target `password.c', needed by `password.lo'. Stop."
23:57 <****> if you do index it, between will be fastest - certainly faster than trying to manipulate already-existing dates
23:58 <****> im sorry, i got disconnected
23:58 <****> adaptr: were you addressing me? i only got your very last message
23:58 <****> the most efficient way is to use an index
23:58 <****> and then use BETWEEN
23:59 <****> BETWEEN 2007-01-01 AND 2008-01-01
23:59 <****> oh i see
23:59 <****> thank you!
23:59 <****> using calculated values and then comparing those will always be slower, obviously - avoid whenever possible
--- Log closed Sat Nov 10 00:00:09 2007

Total 27 pages. You are browsing page 27/27.

First :: Prev :: [...] [23] [24] [25] [26] [27] :: Next :: Last