MySQL Forums
Forum List  »  Microsoft SQL Server

converting constraint from ms sql to mysql
Posted by: Jignesh Patel
Date: November 19, 2013 10:10AM

I am trying to convert a constraint script from ms sql format to mysql and face problem.
The script is:
alter table region add constraint pkregion PRIMARY KEY CLUSTERED (region_cd) on 'default';
the error is:
ERROR 1064 (42000): 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 'on 'default'' at line 1

How would I can smoothly convert this constraint to mysql format?

I did use online utility but gives me same output.
http://burrist.com/mstomy.php

Options: ReplyQuote


Subject
Written By
Posted
converting constraint from ms sql to mysql
November 19, 2013 10:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.