I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message >> configure:error: no acceptable C compiler found in $PATH It is very likely that if he typed which cc or which gcc the reply would come back No cc (gcc) in ... (a list of directories). Either gcc is not installed or the PATH variable is set incorrectly. To check how the path variable is set, type echo $PATH Take care of that problem and try the install again. Emile State on 7/11/03 10:24 AM, harm at [EMAIL PROTECTED] wrote: > On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote: >> Hi there. I am a rank amateur at this trying to make sense out of a heap (and >> growing) of data. >> >> I have a resultset with this structure: >> >> no data date >> 1 uyt d1 >> 1 klh d2 >> 1 oiu d3 >> 2 kjh d1 >> 2 kljh d2 >> 2 asd d3 >> >> that I wish to convert to this structure. >> >> no d1 d2 d3 >> 1 uyt klh oiu >> 2 kjh kljh asd > > something like: > select no.no, d1.data, d2.data, d3.data from no, data as d1, data as d2, data > as d3 where no.no = d1.no and no.no = d2.no and no.no = d3.no order by > no.no; > > Good luck, > > Harmen > > >> >> Given that the original has over 100,000 records, I was hoping to find some >> reasonable way of doing it. >> >> Thanking you, >> >> PhilE >> -- Emile & Marion State 132 Thornway Ave Thornhill, ON L4J 7Z3 (905) 669-5652 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]