Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Web Tools Project (WTP) » SQL script will not run correctly
SQL script will not run correctly [message #215863] Fri, 20 June 2008 20:08
Eric Hamacher is currently offline Eric HamacherFriend
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
Previous Topic:Stop the red wavy line thing in Javascript?
Next Topic:Problem with publishing several WSDL files
Goto Forum:
  


Current Time: Fri Nov 28 21:00:46 GMT 2014

Powered by FUDForum. Page generated in 0.05060 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software