MySQL throws error even though query syntax is correct

Question

This has got be stumped. I've almost literally copied this query directly into heidiSQL's query field and run it successfully.

I'm getting this error

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 ';
INSERT INTO dots(`name`, `sambandsnr`, `dslam`, `ip`, `lat`, `lng`, `on' at line 1

On this query

DELETE FROM dots;

INSERT INTO dots(`name`, `sambandsnr`, `dslam`, `ip`, `lat`, `lng`, `online`)
VALUES
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "..."),
    ("...", "...", "...", "...", "...", "...", "...");

The real script has real data and around 800 rows. Seriously, I have copy&pasted the first 10 rows and run the query manually successfully. That completely stumps me as to how there can be an error at line 1.

Any help would be appreciated

Edit: I just copied the ENTIRE failing script into the query editor and ran it. It ran successfully. !?!?!?

I often get this when I'm using a reserved word. But it seems your not. Have you tried scaling down and see when it breaks? Try adding a single row without some of the columns and see if it works. Then add columns incrementally to see when it breaks. — Kristoffer Lindvall
– Kristoffer Lindvall, Commented Mar 28, 2011 at 12:03

Quassnoi · Accepted Answer · 2011-03-28 11:58:36Z

4

You seem to send two queries at once.

Either send them separately, or use a multi-query function to do that (mysqli_multi_query in PHP).

To do this you have to use MySQLi extension: MySQL extension is not able to send multiple queries in one statement.

From the documentation:

mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.

answered Mar 28, 2011 at 11:58

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

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

2 Comments

Hubro Over a year ago

I'm using mysqli::query. Is there an object oriented way of using your function? EDIT: mysqli::multi_query works, thanks

Quassnoi Over a year ago

@Codemonkey: sure, mysqli::multi_query

Collectives™ on Stack Overflow

MySQL throws error even though query syntax is correct

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related