MYSQL Table Columns HELP..

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
pavanpuligandla
Forum Contributor
Posts: 130
Joined: Thu Feb 07, 2008 8:25 am
Location: Hyderabad, India

Re: MYSQL Table Columns HELP..

Post by pavanpuligandla »

thnq..
yep i got an idea,,
so i decided to use as many columns as i need for my table.(columns<25)
if i do like this, i will not be maintaining relationship wid the rest of tables..is this okay?
only users and their UNIQUE ID's table will be related..
will it create any new problems in maintaining 25 columns and 150 tables around?
yes u r rite, there is no use of splitting up the columns..this will create problem during data entry for administrator :wink: .as he has to enter ID some 30-40 times.,looks awkward..

thnx mate for ur valuable suggestions..
so i'm now clear with wht u've suggested me..

my last query:
i.will it create any new problems in maintaining 25 columns and 150 tables around?
ii. will it be a good database practise if only fewer tables of my DB contain 1-1 or many-many relations?
Many Thanx mate,
pavan.p
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: MYSQL Table Columns HELP..

Post by jaoudestudios »

Why 150 tables?

I suggest you build the database and post the schema that way we can see the true database structure and relationships.
User avatar
pavanpuligandla
Forum Contributor
Posts: 130
Joined: Thu Feb 07, 2008 8:25 am
Location: Hyderabad, India

Re: MYSQL Table Columns HELP..

Post by pavanpuligandla »

i'll send u my DB schema and relationships.
can u please provide me ur email id?
so that i can send u easily, we can discuss Db issues here itself.
many thanks,
pavan.p
Post Reply