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!
Are you just trying to write queries or dump it into a csv or excel? What tools are you using also.
Brian
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..
post up the diagram.
Lance
TLCA Member
2003 4Runner SR5 4x4 Chaos Edition
2000 Toyota Landcruiser
19xx M416 Trailer
Chaos Edition Profile
Operation Rebuilding Chaos Edition
01001001001001110110110100100000011000010010000001 11011101100101011000100111011101101000011001010110 010101101100011001010111001000100001
You are pretty much doing stuff as complicated as I ever have to do, not sure i'm going to be much help.
Brian
Are you writing SQL queries or a PHP script to run the results?
2010 Sequoia Limited Black - Bils UCA & Shocks, Borla Cat back, Morimoto Headlights
2019 4Runner TRD Off Road Premium Dark Blue w/TRD Gunmetal Wheels - Kings/OME, 285/70R17 Nitto Ridge Grapplers, SSO BMC, TRD Skid, Victory 4x4 Blitz Sliders and Front Bumper, BD Fogs & Light Bar, Morimoto Headlights, Prinsu Rack
2023 Tacoma Trail White w/Bronze wheels - CBI T3 Side Steps