#1064 - You have an error in your SQL syntax when creating a View

Question

What's wrong with this code that's making it spit back an error?

My code is as follows:

CREATE OR REPLACE VIEW vw_training AS 
SELECT training.train_attended, clients.client_firstname, clients.client_lastname, clients.client_swn, clients.client_id, locations.loc_id, locations.loc_title, locationsp.loc_id, locationsp.loc_title, 
FROM training 
JOIN clients ON clients.client_id = training.train_clientid
JOIN locations AS locationsp ON locations.loc_id = training.train_pickup
LEFT JOIN locations ON locations.loc_id = clients.client_winz

And this is the error I'm getting back:

#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 training JOIN clients ON clients.client_id = training.train_clientid JOIN' at line 3

I'm running phpMyAdmin version 3.5.2.2.

I've used this script with different values before with no issues.

Why downvoted? Legitimate question. Everybody makes mistakes. Upvoted. — user2757572
– user2757572, Commented Nov 5, 2017 at 10:46
This question can be closed as Typo/No Repro, since typo questions aren't likely to be useful for future readers. — halfer
– halfer, Commented Mar 20, 2023 at 9:55

John Woo · Accepted Answer · 2013-04-23 02:01:23Z

1

You have an extra trailing comma before the FROM clause

SELECT ....,
       locationsp.loc_id, 
       locationsp.loc_title, -- <<== remove this trailing comma
FROM   training ...

and another error that will raise this message: Unknown column 'locations.loc_id' in 'on clause' is the use of tablename and not the alias supplied. it should be,

JOIN locations AS locationsp ON locationsp.loc_id = training.train_pickup
                                    ^^ should use alias here

edited Apr 23, 2013 at 2:01

answered Apr 23, 2013 at 1:55

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

3 Comments

RichardTheKiwi Over a year ago

JOIN locations AS locationsp ON locations.loc_id = training.train_pickup is an error as well

John Woo Over a year ago

@RichardTheKiwi right. it should be JOIN locations AS locationsp ON locationsp.loc_id = training.train_pickup

dpDesignz Over a year ago

@JW Thanks heaps! I can't believe I missed that. :)

Collectives™ on Stack Overflow

#1064 - You have an error in your SQL syntax when creating a View

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related