Recent content by DJDaveMark

Just wondered something else, Would there be any way to get the race_id which belongs to each particular best score i.e... race1 race1_id race2 race3 race4 a. person 9 1 8 8 8 b. person NULL NULL 5 4 NULL c. person...

Thanks again Golom, you were spot on, here's where it led me... SELECT firstName, lastName, MAX( score ) AS Best FROM results, people WHERE people_id = p_id GROUP BY people_id which gave me... firstName lastName Best a person 9 b person 8 c person 9...

Thanks for that Golom, Will have a look into those, and post back where it leads me. Much appreciated, cheers, DJDaveMark

Hi all, I'm fairly new to SQL & I was wondered if there was a single SQL satement that would create something like the following table... race1 race2 race3 race4 a. person 9 8 8 8 b. person 5 5 4 1 c. person 9...

cheers!

Hi all, Being a Java Programmer it's the first time I've designed a database and the queries. I just wondered if the following was ANSI_SQL or if I've added mySQL specific stuff. A quick yes or no would suffice. Any links would be much appreciated.START TRANSACTION; INSERT INTO `race` ( `time`...

Remember that the += operator used with String objects is a shorthand way of the following...static String test(String s) { s = s.concat("11111111"); return s; }As mentioned above, String objects were designed to be immutable so that the object will never be modified. Try some similar...

Hi all, I'm a Java Programmer who's taken on a website project by myself, therefore I've also had to design the database. It will be a mySQL database. I have already designed it and successfully tested that the queries are getting out what was required. Although I'm not sure how portable my...