SQL script will not run correctly [message #215863] |
Fri, 20 June 2008 20:08 |
Eric Hamacher Messages: 4 Registered: July 2009 |
Junior Member |
|
|
MySQL 5.0
WTP 2.0.2
Hello:
I am trying to execute an SQL file using WTP. The problem is that only
the first statement will execute and then it fails. I've been using these
scripts for a long time, so there are no errors in them.
When I execute:
DROP TABLE IF EXISTS family;
DROP TABLE IF EXISTS person;
DROP TABLE IF EXISTS familychild;
DROP TABLE IF EXISTS personsource;
DROP TABLE IF EXISTS marriagesource;
DROP TABLE IF EXISTS audit;
DROP TABLE IF EXISTS user;
the following message results:
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 ';
DROP TABLE IF EXISTS person;
DROP TABLE IF EXISTS familychild;
DROP TABLE ' at line 1
If I select a random statement and execute it works fine. But if more
than one statement is executed it fails. This happens with another SQL
script I have, too.
Anybody seen this?
Thanks
Eric
|
|
|
Powered by
FUDForum. Page generated in 0.01491 seconds