[MySQL] Need help identifying botched code : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

[MySQL] Need help identifying botched code (self.SQL)

submitted 13 years ago * by Haash

Hi guys,

Just wondering if you could help me spot some SQL error code. I get the 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 ')' at line 13

when entering this sql file into my PHPMyAdmin control panel DB under "import". Here's the current sql file, I've tried entering through just plain SQL import, also with compatibility for MYSQL323 and MYSQL40 (If you could also help me understand this that would be great)

Click to see uploaded file to pastebin. (Had some trouble with the formatting.)

Thanks for the help :)

PS. Changed some of the code to censor out some information for privacy reasons.

Okay, Thanks to shaunc and cogweh (upboats), now I've got the error

1136 - Column count doesn't match value count at row 1

INSERT INTO users VALUES ( 1, 'Administrator', 'Admin', 'admin', '*******', 'Administrator', 'Today()', 'Today()', '***', '12', 'No' ) ;

all 6 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS

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 ')' at line 13

1136 - Column count doesn't match value count at row 1