Eclipse Community Forums: ServerTools (WTP)

Help

Home

Home » Language IDEs » ServerTools (WTP) » SQL file(SQL file)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL file [message #1828222]

Thu, 04 June 2020 10:51

Gregory Dimatteo

Messages: 1
Registered: June 2020

Junior Member

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

Report message to a moderator

Re: SQL file [message #1828236 is a reply to message #1828222]

Thu, 04 June 2020 14:43

Nitin Dahyabhai

Messages: 4435
Registered: July 2009

Senior Member

That's a message from your MySQL server. Did you do as it said? And why does the message refer to an apostrophe
that doesn't appear to be in your shown statements?

_
Nitin Dahyabhai
Eclipse Web Tools Platform

Report message to a moderator

Previous Topic:	Some EJBs only get published if project is open in eclipse
Next Topic:	How do I permanently disable smart insert, for all file types, forever?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:53:57 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter