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? -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
