nadeemshafi9 Posted August 15, 2006 Share Posted August 15, 2006 hi guysI am a student and iv been using mysql to put data in to simple table feilds such as images and text i hav used dump files and phpmyadmin. the problem is i hav been given the task for my final project to recreate a huge hospital access relational database in mysql and add an intranet interface using php.My problem is that i cant seem to see how relations are made in mysql and which datatype actualy is the equivalent of autonuber eg for id's ect, do i need to generate these, unique identifier dosent automaticaly enter a number.can somone please help me, thanks alot for any help.Nadeem Quote Link to comment Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 You can auto-increment any integer data type. As for "relations", you can enforce this via InnoDB FKs, but you'll still have to "make" them yourself. Quote Link to comment Share on other sites More sharing options...
nadeemshafi9 Posted August 18, 2006 Author Share Posted August 18, 2006 thanks, very helpfull, issue RESOLVED Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.