LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-05-2011, 04:52 AM   #1
unihiekka
Member
 
Registered: Aug 2005
Distribution: SuSE Linux / Scientific Linux / [K|X]ubuntu
Posts: 273

Rep: Reputation: 32
MySQL: Multiple entries


Hi there!

I just started out trying to learn MySQL (and databases in general!), so I apologize if my question is very basic.

Right now I have a few tables, one of which contains a list of clients with contact details and the usual stuff, and another that has a list of projects that these clients are involved in (with details on the project, deadlines, etc.).

Per project there is a field for clients, where I would like to add the name of the clients, but the problem is that there are a couple of projects that have several clients from my list. Can I simply put multiple entries in one field (how?), or should I find some other way?

Another way is to add a field for the clients with a list of projects they are involved in but they can be involved in more than one project, so the problem remains, or do I need a different approach? I thought about a new table with project IDs and client IDs but that seems so inconvenient...

Thanks. I appreciate any help you can give!

P.S.: Obviously the number of entries is limited by the total number of clients in my table, but usually I don't think that would be a concern.

Last edited by unihiekka; 04-05-2011 at 05:05 AM.
 
Old 04-05-2011, 05:11 AM   #2
unihiekka
Member
 
Registered: Aug 2005
Distribution: SuSE Linux / Scientific Linux / [K|X]ubuntu
Posts: 273

Original Poster
Rep: Reputation: 32
Ah, I have just been reading on database normalization, and it seems that I suffer from what is known as "Spreadsheet Syndrome". Well, off to create additional tables to make them all nice and normalized!
 
Old 04-05-2011, 06:14 AM   #3
brownie_cookie
Member
 
Registered: Mar 2011
Location: Belgium
Distribution: CentOS release 5.5 (Final), Red Hat Enterprise Linux ES release 4 (Nahant Update 8)
Posts: 416
Blog Entries: 2

Rep: Reputation: 12
if you find your answer yourself, pls mark this thread as solved
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
GRUB 2 - multiple entries dreamweaver547 Ubuntu 5 12-13-2009 12:32 PM
Multiple GRUB entries BrianPritchard Linux - Newbie 1 11-17-2008 09:40 AM
Hacked ? Multiple who entries...... budword Linux - Security 4 09-06-2007 07:49 PM
gnucash: change multiple entries pixellany Linux - Software 0 05-25-2007 08:30 PM
Multiple same entries in volume controls or1onas Linux - Newbie 4 02-07-2005 01:21 PM


All times are GMT -5. The time now is 10:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration