SQL-Syntax Check

Hello Users does anyone know a tool or a way for validation sqlcode on the command_line??? For example ./sqlsyntaxchecker < "select * f test" --> Error not valid sql syntax thx christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: Syntax Check: Group BY with Joins

AIL PROTECTED]> To: "'Eric Ellsworth'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 27, 2004 10:09 AM Subject: RE: Syntax Check: Group BY with Joins > Eric > > Try putting the "HAVING" clause after group by. I believe >

RE: Syntax Check: Group BY with Joins

Eric Try putting the "HAVING" clause after group by. I believe "having" is the last clause (may be LIMIT). David > -Original Message- > From: Eric Ellsworth [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 8:01 AM > To: [EMAIL PROTECTED] > S

Syntax Check: Group BY with Joins

Hi, I'm having trouble with this query: SELECT Max(DATE_ADD('1970-1-1',INTERVAL Lastupdate/3600/24 DAY)) as BaskDate, ofm_baskets.Code, Sum(ofm_baskets.Quantity) AS TotalQty FROM (ofm_basklist INNER JOIN ofm_basklupd ON ofm_basklist.Session_id = ofm_basklupd.Session_id) INNER JOIN ofm_basket

RE: Syntax check

On 18-Mar-01 Rodney J. Woodruff wrote: > Can someone look at this syntax and tell me what is wrong with it. Any > and all help is appreciated. I worked with several databases and have > never had any trouble writing CREATE statements in the past. > > I get the following error when I run this c

Syntax check

Can someone look at this syntax and tell me what is wrong with it. Any and all help is appreciated. I worked with several databases and have never had any trouble writing CREATE statements in the past. I get the following error when I run this create statement. So what is wrong with my syntax.