At 08:07 PM 2/14/2007 -0800, you wrote: >Ken Dibble wrote: > > This is pretty strange. I run the following commands in the MySQL 5.0 > > command line program: > > > > DELETE FROM musBands WHERE 1 = 1; > >You don't need "WHERE 1=1"; just "DELETE FROM musbands" will do it. > > > LOAD DATA LOCAL INFILE 'c:/DaboProjects/MyMusic/bandtxt.txt' INTO TABLE > > musBands; > > > > Everything works fine. > > > > Then I run a script that contains those two lines after some other tables > > are loaded, and I get ERROR 1064 (syntax error). > > > > I run the script using: > > > > source 'c:/mypath/myfile.sql'; > > > > Here's the script: > > > > DELETE FROM musSongs WHERE 1 = 1; > > > > LOAD DATA LOCAL INFILE 'c:/DaboProjects/MyMusic/songtxt.txt' INTO TABLE > > musSongs; > > > > DELETE FROM musPeople WHERE 1 = 1; > > > > LOAD DATA LOCAL INFILE 'c:/DaboProjects/MyMusic/peotxt.txt' INTO TABLE > > musPeople; > > > > DELETE FROM musBands WHERE 1 = 1; > > > > LOAD DATA LOCAL INFILE 'c:/DaboProjects/MyMusic/bandtxt.txt' INTO TABLE > > musBands; > > > > The first two tables load just fine. I get the error on the third > table, on > > commands that work just fine when run directly in the command line program. > > > > Does this make any sense? > >Not really, can you post the actual text of the error you receive?
Nope, I can't make it happen any more. I did a DROP DATABASE, re-ran my script to create the tables, then re-ran my data loading script and the error didn't happen. That doesn't make any sense either--but I'm glad it's fixed. Thanks. Ken -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.17.39/687 - Release Date: 2/14/2007 4:17 PM _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
