MySQL Forums
Forum List  »  Newbie

query works on mysql windows version ,but not on mysql solaris version
Posted by: sb_mali
Date: June 17, 2005 07:34AM

hello
i am getting following errors while executing the perl script on solaris machine.
same script works fine when i run it on windows .

the query i am using is
select tbl.errcode,avg(tbl.cnt) from (select date,errcode,count(errcode) cnt from websec where errcode in ('WIP663','WIP701') group by date,errcode) as tbl group by tbl.errcode;

Please suggest why the query which is working fine on windows is giving problems with mysql on solaris.

i am using mysql version 4.1 on windows and solaris.

DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select date,errcode,count(errcode) cnt from websec where errcod at websec-v55.pl line 531.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at websec-v55.pl line 538.
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select date,errcode,count(errcode) cnt from websec where errcod at websec-v55.pl line 667.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at websec-v55.pl line 674.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.