CONCAT_WS and NULL

2012-12-11 Thread hsv
This is, maybe, a question of taste. I find it useful in the aggregate functions that they ignore all NULLs that come under their purview, but yield NULL if nothing else comes. Now, CONCAT_WS is no aggregate function, but is like them in that it ignores all NULLs that come its way, aside from th

Re: Help with left outer join

2012-12-11 Thread Peter Brawley
>ERROR 1054 (42S22): Unknown column 'data_tool.category_id' in 'on clause' >But category_id is a column in data_tool. Then a bit of reordering is required ... SELECT data_target.name, ep, wafer_id, lot_id, date_time, data_file_id, data_cstimage.name, bottom, wf_file_path_id, data_m

Re: Help with left outer join

2012-12-11 Thread hsv
2012/12/11 16:19 -0500, Larry Martell I have this query: SELECT data_target.name, ep, wafer_id, lot_id, date_time, data_file_id, data_cstimage.name, bottom, wf_file_path_id, data_measparams.name, vacc, data_category.name FROM data_cst, data_target, data_cstimage, dat

Re: Help with left outer join

2012-12-11 Thread Larry Martell
On Tue, Dec 11, 2012 at 5:12 PM, Peter Brawley wrote: > > On 2012-12-11 3:19 PM, Larry Martell wrote: > > I have this query: > > SELECT data_target.name, ep, wafer_id, lot_id, >date_time, data_file_id, data_cstimage.name, >bottom, wf_file_path_id, data_measparams.name, >vac

Re: Help with left outer join

2012-12-11 Thread Peter Brawley
On 2012-12-11 3:19 PM, Larry Martell wrote: I have this query: SELECT data_target.name, ep, wafer_id, lot_id, date_time, data_file_id, data_cstimage.name, bottom, wf_file_path_id, data_measparams.name, vacc, data_category.name FROM data_cst, data_target, data_cstimage, d

MySQL Community Server 5.6.9-rc has been released

2012-12-11 Thread Joerg Bruehe
Dear MySQL users, MySQL Server 5.6.9 (Release Candidate) is a new version of the world's most popular open source database. The new features in this release are of Release Candidate quality. As with any other pre-production release, caution should be taken when installing on production level syst

Re: Problem accessing phpmyadmin using IP from remote machine

2012-12-11 Thread Girish Talluru
Hi Abhishek, Yes I can do that. On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain wrote: > Can you ping ip 192.168.1.9 from other machines? > On Dec 11, 2012 11:21 AM, "Girish Talluru" > wrote: > >> Hi Guys, >> >> I have environment as specified below. >> >> Main server: Windows Server 2008 >> Vir