Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jggretton

    Problems quering 3 tables in one statment (GROUP BY)

    Awesome thanks piti. That works like a charm. I was under the false impression that my mySQL version didn't support joins - I couldn't have been more wrong! Because I didn't think I supported them, i've never taken the time to learn about them before. That'll change now! Many thanks, James
  2. jggretton

    Problems quering 3 tables in one statment (GROUP BY)

    Hello, below is my rather complecated sql query. It does two things: a) Gets all the articles in catagory '4' b) Gets all the articles in catagories with parent catagory '4' (a) and (b) run fine on their own, but when i combine them with an OR statement, i get multiple (seemingly) redundant...
  3. jggretton

    Copy of auto_increment column

    Fantastic, very pleased i don't have to worry about the insert id changing. Thanks to both of you for your help! James
  4. jggretton

    Copy of auto_increment column

    Hello, i've got an `id` column which auto_increments, but I also would like another column initially set to the same number as `id`. Is this a sensible way of doing this on mySQL 4.0.26: "INSERT INTO `bla` ( `id` , `id2`, `text`) VALUES ('', '', 'Bob'); UPDATE `bla` SET `id2`=LAST_INSERT_ID( )...

Part and Inventory Search

Back
Top