Welcome to Geeklog, Anonymous Sunday, February 05 2023 @ 12:13 pm EST

Geeklog Forums

#1064 - You have an error in your SQL syntax


I am trying to import data that is tab delimited. The error message I receive is:

#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 'john smith 123 main your town ca 94566 ' at line 1

The data between the ' ' is artificial for this example due to the sensitivity of the original data. Each item here represents a column of data " int, text and varchar" and so forth. My question is do I need to construct my data differently, another type of separation for mySQL to understand it properly? (I.E. comma or so forth).

I am using:

Server: Localhost via UNIX socket
Server version: 5.1.44
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1
MySQL client version: 5.1.44
PHP extension: mysql


Version information: 3.2.4
Official Homepage
[ChangeLog] [Subversion] [Lists]


Status: offline


Forum User
Registered: 05/19/10
Posts: 136
How are you importing this data? Through phpMyAdmin or at the MySQL console?
Do you have any quotes in your data: single quotes, double quotes, backticks?

Error 1064 generally means that you used some reserved word that you aren't meant to, but since you have posted some random data and no SQL statement to go with it, I can't tell for sure. Full list of reserved words here: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html


All times are EST. The time is now 12:13 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content