Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

errors in mysql syntax

From: RAMYA <ramyayellow(at)rediffmail.com>
Date: Fri Sep 28 2007 - 02:10:35 EDT

ALTER TABLE TimeTracker.TT_ProjectMembers ADD

        CONSTRAINT FK_Roles_Projects FOREIGN KEY 
        ( 
                ProjectID 

) REFERENCES TimeTracker.TT_Projects (
ProjectID
) ON DELETE CASCADE ,
CONSTRAINT FK_WorksOn_Users FOREIGN KEY ( UserID
) REFERENCES TimeTracker.TT_Users (
UserID
)

As iam new to this mysql when i was doing the program mysql shows the error as

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 'CONSTRAINT FK_WorksOn_Users FOREIGN KEY

        ( 
                UserID 

) REFERENCES TimeTracke' at line 8

what to do if this error comes plz anyone help me

-- 
View this message in context: 
http://www.nabble.com/errors-in-mysql-syntax-tf4532650.html#a12935188
Sent from the MySQL - General mailing list archive at Nabble.com.


-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com
Received on Fri Sep 28 02:11:23 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:12:34 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library