mysql statement returns syntax error

Question

For some reason I get the following error when running the code below:

#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 postcodes_demographics INNER JOIN latlon1 on postcodes_demographics.postc' at line 3

I don't understand what I'm doing wrong, thanks for any suggestions!

INSERT INTO pslatlong
    SELECT postcodes_demographics.*, latlon1.*,
    FROM postcodes_demographics
    INNER JOIN latlon1
    on postcodes_demographics.postcode = latlon1.postcodens;

Remove the comma at the end of the select clause.

Raging Bull
– Raging Bull

2014-04-24 12:56:46 +00:00
Commented Apr 24, 2014 at 12:56 — Raging Bull
– Raging Bull, Commented Apr 24, 2014 at 12:56

John Conde · Accepted Answer · 2014-04-24 12:56:06Z

1

You have an errant comma:

 SELECT postcodes_demographics.*, latlon1.*, <--- HERE

Remove it.

answered Apr 24, 2014 at 12:56

community wiki

John Conde

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

Comments

Gordon Linoff · Accepted Answer · 2014-04-24 13:00:38Z

1

I would be very surprised if merely removing the comma fixes the problem. When using insert, you should get in the habit of listing all the columns explicitly:

INSERT INTO pslatlong(col1, col2, . . . )
    SELECT d.col1, l.col2, . . .
    FROM postcodes_demographics d INNER JOIN
         latlon1 ll
         on d.postcode = ll.postcodens;

You need to do this to be sure that the right column is assigned the right value, to allow auto incrementing columns to be auto-incremented, and to prevent problems based on the number of columns.

answered Apr 24, 2014 at 13:00

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Comments

Raging Bull · Accepted Answer · 2014-04-24 12:58:00Z

0

This may works:

INSERT INTO pslatlong
 SELECT postcodes_demographics.*, latlon1.*
 FROM postcodes_demographics
 INNER JOIN latlon1
 on postcodes_demographics.postcode = latlon1.postcodens;

edited Apr 24, 2014 at 12:58

Raging Bull

18.8k13 gold badges52 silver badges56 bronze badges

answered Apr 24, 2014 at 12:57

Vinicius

611 silver badge9 bronze badges

Collectives™ on Stack Overflow

mysql statement returns syntax error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related