Jump to content

dhinok

Members
  • Posts

    3
  • Joined

  • Last visited

Everything posted by dhinok

  1. Man the query worked perfectly, thanks a lot. There's a little problem though. I added another category in table CAT with value 'polo'. But this category doesn't exist in table STUDENTS then if i try to update CAT.category polo to something else then it won't update. so what do i use for that?
  2. What I meant is that:When I update field skiing (lets say to volleyball) from table CAT then it updates all the the rows from table STUDENTS that have skiing in their category field to volleyball (id 1, 2, and 7 from STUDENTS updates to volleyball)Was that specific enough? Thanks
  3. Hi everyone!I have this probem. I have two table in mysql database:Table1: catID CATEGORY1 football2 swimming3 baseball4 basketball 5 skiingTable2: studentsID NAME category1 jon skiing2 may skiing3 jack skiing4 li football5 sonny basketball 6 joe baseball7 jan skiing8 kate swimmingNow my problem is:How can I update table1: cat.category by also affecting corresponding values of table2: students.category using inner join or any other sql query?Please help, thank you Jim
×
×
  • Create New...