#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version -

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version -

i using sybase powerfulness designer create database physical info model (sybase creates sql file) . when import sql file phpmyadmin have next error:

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'if exists(select 1 sys.sysforeignkey role='fk_artwork_creates_artist'' @ line 7 .

any ideas? error appear due errors on physical model or there problem?

this code :

if exists(select 1 sys.sysforeignkey role='fk_artwork_has_buy') alter table artwork delete foreign key fk_artwork_has_buy end if;

the error getting mysql. regardless of tool used generate sql, database seems mysql (or terribly wrong systems if confused , think mysql).

the mysql if statement (documented here) has within stored program. means code compiles within stored procedure, user defined function, or trigger. doesn't "just work" on own.

in addition, mysql doesn't have sys tables. uses information_schema tables. strongest suggestion utilize tools appropriate actual database. if using tool generate sybase, utilize sybase destination database. if using mysql, utilize tool generate mysql code. or, improve yet, larn how write commands yourself.

finally, if intend utilize sybase, connect right database , problem should fixed.

mysql sql sybase mysql-error-1064 powerdesigner