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 Link to comment https://forums.phpfreaks.com/topic/17593-need-guidence-on-creating-relational-db/ 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. Link to comment https://forums.phpfreaks.com/topic/17593-need-guidence-on-creating-relational-db/#findComment-75104 Share on other sites More sharing options...
nadeemshafi9 Posted August 18, 2006 Author Share Posted August 18, 2006 thanks, very helpfull, issue RESOLVED Link to comment https://forums.phpfreaks.com/topic/17593-need-guidence-on-creating-relational-db/#findComment-76669 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.