Database stuff...MySQL

[callmej75]

Anyone familiar with extracting data from tables? This class is kicking my arse and finding the right wording to extract this data is a pain. If anyone is willing to help it would be highly appreciated!

[tulsa_sr5]

Are you just trying to write queries or dump it into a csv or excel? What tools are you using also.

[callmej75]

Just trying to write the queries...we use a free tool from school called aquadata studio and we run through the apache server. We also use MySQL Server 2000/5 mainly since MySQL requires different syntax and wording.

Here is a sample question from the homework:

Find out how many times a certain staff member waited on each customer. Only include those where the staff member waited on them over 22 times. Order the output by the customer number. List the customer number, the staff number, and the number of times they were waited on.

I got an ER Diagram printed out to let me know which things link the tables. We are doing counts and order by's in aggregates so its getting tougher..

[Good Times]

post up the diagram.

[callmej75]

http://i10.photobucket.com/albums/a128/callmej75/Diagram.jpg

[tulsa_sr5]

You are pretty much doing stuff as complicated as I ever have to do, not sure i'm going to be much help.

[callmej75]

This is a pain..I like web design more!

[Cebby]

Are you writing SQL queries or a PHP script to run the results?

[callmej75]

SQL queries to extract data from tables.I've been working with Lance and he is helping tremendously...but some small things were trying to figure out.