cannot find SQL syntax error [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 9 years ago.

Improve this question

i am trying to run this SQL Query:

SELECT avg(response_seconds) as s FROM 
    ( select time_to_sec( timediff( from_unixtime( floor( UNIX_TIMESTAMP(u.datetime)/60 )*60 ), u.datetime) ) ) as response_seconds 
    FROM tickets t JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber 
    WHERE u.type = 'update' and t.customer = 'Y' and DATE(u.datetime) = '2016-04-18' 
    GROUP BY t.ticketnumber) 
    AS r

but i am seeing this error:

#1064 - 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 'FROM tickets t JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber WHE' at line 3

and i cannot work out where the error is in the query

Looks like you closed ) too early before as response_seconds. That belongs inside the (select...) but you have it outside. The correct syntax to use near FROM means you must look immediately before that to find the issue. — Michael Berkowski
– Michael Berkowski, Commented Apr 28, 2016 at 17:16
You have 2 FROMs - One from the nested query and the second from tickets, you need to JOIN tickets to the query — Alon Eitan
– Alon Eitan, Commented Apr 28, 2016 at 17:16
You have 6 opening (, which should be finally closed after GROUP BY, but the 6th closing ) occurs just before as response_seconds instead. — Michael Berkowski
– Michael Berkowski, Commented Apr 28, 2016 at 17:18

RiggsFolly · Accepted Answer · 2016-04-28 17:26:55Z

2

Remove the ) just before as response_seconds

SELECT avg(response_seconds) as s FROM 
    ( select time_to_sec( timediff( from_unixtime( floor( UNIX_TIMESTAMP(u.datetime)/60 )*60 ), u.datetime) ) as response_seconds 
      FROM tickets t 
         JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber 
      WHERE u.type = 'update' 
        and t.customer = 'Y' 
        and DATE(u.datetime) = '2016-04-18' 
      GROUP BY t.ticketnumber
    ) AS r

You had to many closing brackets on that calculation which had the effect of closing the sub select to early.

edited Apr 28, 2016 at 17:26

answered Apr 28, 2016 at 17:21

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alon Eitan Over a year ago

But then you have FROM response_seconds and FROM tickets?

RiggsFolly Over a year ago

Its a sub query, it need a FROM

Alon Eitan Over a year ago

Oh, now after the aligning, I see you're correct. +1

Arulkumar · Accepted Answer · 2016-04-28 17:28:45Z

) the one more extra parenthesis in the ) ) as response_seconds causing the problem, removing that will solve the problem. For better readability I aligned the code:

SELECT avg(response_seconds) AS s 
FROM 
( 
    SELECT 
        time_to_sec( 
            timediff( 
                from_unixtime( 
                    floor( 
                            UNIX_TIMESTAMP(u.datetime)/60 
                        )*60 
                ), u.datetime
            )   -- ) the one more extra parenthesis causing the problem
        ) as response_seconds 
    FROM tickets t 
    JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber 
    WHERE u.type = 'update' and t.customer = 'Y' and DATE(u.datetime) = '2016-04-18' 
    GROUP BY t.ticketnumber
) AS r

Frederick Álvarez · Accepted Answer · 2016-04-28 17:22:38Z

0

It seems that you have an extra ')' here "tetime) ) ) <-- as response_seco"


SELECT avg(response_seconds) as s
FROM (
      select time_to_sec( timediff( from_unixtime( floor( UNIX_TIMESTAMP(u.datetime)/60 )*60 ), u.datetime) ) as response_seconds 
      FROM tickets t JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber 
      WHERE u.type = 'update' and t.customer = 'Y' and DATE(u.datetime) = '2016-04-18' 
      GROUP BY t.ticketnumber
    ) AS r

answered Apr 28, 2016 at 17:22

Frederick Álvarez

5821 gold badge7 silver badges23 bronze badges

Comments

David · Accepted Answer · 2016-04-28 17:18:19Z

-1

Count your parentheses. You're essentially doing this:

SELECT some_column as s
FROM some_sub_select as response_seconds 
FROM tickets t JOIN ticket_updates u ON t.ticketnumber = u.ticketnumber 
....

You can't have two FROM clauses in the same query.

Maybe you have mis-aligned parentheses? Maybe you meant to do a JOIN instead of a second FROM? It's difficult to tell from what appears to be an incomplete overall query.

answered Apr 28, 2016 at 17:18

David

221k42 gold badges245 silver badges337 bronze badges

Collectives™ on Stack Overflow

cannot find SQL syntax error [closed]

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Related