mona Posted March 29, 2006 Share Posted March 29, 2006 hi, I'm doing a project on my laptop and my professor asked me to put my stuff on a certain server related to the university, when I did that I saw that my stuff is working there but the problem of foreign key constraint appears,on my laptop I'm using mysql 4.1 , on the server they told me that they are using mysql 4actually, on my mysql you can't delete a record if it's key is used by another table, they told you that it is a foreign key constraintbut on the server you can delete the record although it's key is used as a foreign key in other tables record which is wrong.Is this a problem in mysql version or what.and can I change something to solve it. Link to comment Share on other sites More sharing options...
aspnetguy Posted March 29, 2006 Share Posted March 29, 2006 if you are using phpMyAdmin to administer the mysql databses I would recommend exporting them to sql or text (for both laptop and server versions) then compare the output sql and make sure they are 100% the same.It may be a simple inconsistancy. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now