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 biv343 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: *

  • Users: jggretton
  • Content: Threads
  • Order by date
  1. 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...
  2. 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