Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 04-05-2011, 03:52 AM   #1
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 04:05 AM.
Old 04-05-2011, 04:11 AM   #2
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, 05:14 AM   #3
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


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 11:32 AM
Multiple GRUB entries BrianPritchard Linux - Newbie 1 11-17-2008 08:40 AM
Hacked ? Multiple who entries...... budword Linux - Security 4 09-06-2007 06:49 PM
gnucash: change multiple entries pixellany Linux - Software 0 05-25-2007 07:30 PM
Multiple same entries in volume controls or1onas Linux - Newbie 4 02-07-2005 12:21 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:53 PM.

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