Re: temp tables mysql OT

2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta: > Hi gang: > > Another mysql question. > > I would like to create a temporary table to perform searches. > > From my main table, I need to exclude records that have certain > fields that are null or empty; and then sort the final result. why do you need a temp table for that? select * from blah where not isnull(checkfield) and checkfield <> '' order by someotherfield greets Zoltán Németh > > I've spent over an hour looking at "How do I set up a temporary table > in MySQL?" questions via Google with little help. My eyes and brain > are blurry -- giving it up for tonight. > > Anyone have a sample or a clear reference for me to review? > > Thanks in advance guys. > > Cheers, > > tedd > > PS: Watch someone (maybe everyone) jump on "This ain't a MySQL list." > > -- > ------- > http://sperling.com > http://ancientstones.com > http://earthstones.com >