Jump to content

Archived

This topic is now archived and is closed to further replies.

nadeemshafi9

need guidence on creating relational DB

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.