How to create fast database queries

Assigning people

Comments enabled. I *really* need your comment

Answering questions asked on the site.

Greg asks:

I have two tables, tasks and resources.

Tasks contains cost of each task: first requires 5 people to complete, second requires 3 people etc.

Resources is just a list of people.

How do I assign people to tasks?

This is in MySQL.

Thanks for a nice question, Greg.

Unfortunately, you haven't sent your table structure, so I will have to make it up.

Let's create the tables:

Table creation details

Written by Quassnoi

May 4th, 2009 at 11:00 pm

Posted in MySQL

Leave a Reply