MySQL Forums
Forum List  »  Newbie

different number of fields/collumns in records
Posted by: Eelco ten Have
Date: January 30, 2011 05:44AM

Hi,

I am a relative database newbie.
I'd like to create a database in which i put the info i learn at school about chinese medicine.

Now I need a table that describes acupuncture points.
but each point has a different number of effects.

Also for this year i only need a few effects to be added to next year.

How do I go about that.
Using phpmyadmin I have to set a table name and a number of fields...

Say the point with the biggest number of effects is 10 and the least is 1.
Can i just add 10 fields and allow null for the ones i dont need?

Regards Eelco

Options: ReplyQuote


Subject
Written By
Posted
different number of fields/collumns in records
January 30, 2011 05:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.