DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 03-13-2007, 04:20 AM   #1
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default SQL Syntax Error

Code:
load data local infile 'D:/CITY/SAMPLE.TXT' INTO TABLE 'sample7';
I am trying to run this SQL code with MySQL-Front, but I always get a SQL syntax error. I want to reload my table with a different structure for the table, and not having any luck. I did the import this once before, but now I cannot remember how I succeeded.

I am trying to follow the books and the MySQL examples, but it doesn't seem to matter the order of various parameters, or which ones are added or dropped. I have tried many variations, and all get the same error message.

Quote:
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 ''sample7'' at line 1
Any ideas?
dthomsen8 is offline   Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Quark 6.5 - Disable error messages bmann Print Design 7 08-05-2006 11:49 AM
InvalidFont error djb Print Production & Automation 1 05-19-2006 06:37 AM
Acrobat Reader throws up error Hugh Wyn Griffith The Corner Pub 12 03-22-2006 02:33 PM
Acrobat 7 Pro Win installation error Robin Springall Print Production & Automation 28 01-12-2006 04:48 PM
Custom 404 error page... terrie Web Site Building & Maintenance 15 02-24-2005 12:32 PM


All times are GMT -8. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.