Tim ~ I need two sets of data that are guaranteed to be identical (except for the= columns I want to lose in the second set) - but querying twice, even if performed= one immediately after the other, does not guarantee me identical counts etc. as I am talking to a busy= MySQL server.
By transform I merely refer to 'losing a set of columns'. Clear as mud? Kai On Thu, 29 Nov 2007 09:29:27 -0900, Tim Johnson wrote: > > On Thursday 29 November 2007, Kai Peters wrote: >> I need to transform SQL cursors with up to 10,000 records and it needs to= be=3D fast: >> >> Example cursor: >> >> [ >> [ 100 "Joe Browne" "Chicago" 55 445-5689 ] >> [ 101 "Joe Browne" "Chicago" 55 223-2221 ] >> [ 102 "Joe Browne" "Chicago" 55 489-5555 ] >> [ 103 "Joe Browne" "Chicago" 55 235-2245 ] >> ] >> >> I need a copy of this cursor, but only containing certain fields from= each=3D record; >> the desired fields should be specified in a block like: >> >> [ 1 2 5 ] if I wanted record #, name & phone from each record in the= example above. >> > Hi Kai: > I'm not sure if I fully understand your need, but if you are looking for= column values 1, 2 & 5, > why not compose your SQL query to those specific columns in that order? as= in "select > col1,col2,col5 from MyTable"? If I've missed the boat here - sorry! Oh,= and what do you mean by > 'transform'? regards tim -- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
