Jump to content


Photo

need guidence on creating relational DB


  • Please log in to reply
2 replies to this topic

#1 nadeemshafi9

nadeemshafi9
  • Members
  • PipPipPip
  • Advanced Member
  • 1,245 posts
  • LocationUK

Posted 15 August 2006 - 08:28 AM

hi guys

I 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
DONT LAY AN EGG OVER IT

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 August 2006 - 01:57 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 nadeemshafi9

nadeemshafi9
  • Members
  • PipPipPip
  • Advanced Member
  • 1,245 posts
  • LocationUK

Posted 18 August 2006 - 09:50 AM

thanks, very helpfull, issue RESOLVED
DONT LAY AN EGG OVER IT




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users