Difference between revisions of "Technical Notes"

From Kbwiki
Jump to: navigation, search
Line 6: Line 6:
  
 
* Query to update <b>trap</b> table using values from <b>trap_routes</b> table:
 
* Query to update <b>trap</b> table using values from <b>trap_routes</b> table:
  UPDATE  
+
  UPDATE trap, trap_routes  
  trap, trap_routes  
+
  SET trap.trap_route=trap_routes.trap_route, trap.trap_route_sequence=trap_routes.trap_route_sequence  
  SET  
+
  WHERE trap.trap_id=trap_routes.trap_id
  trap.trap_route = trap_routes.trap_route,
+
  trap.trap_route_sequence = trap_routes.trap_route_sequence  
+
  WHERE  
+
  trap_routes.trap_id = trap.trap_id
+

Revision as of 12:52, 16 January 2008

  • Query to find unmatched trap_id's:
SELECT trap_routes.trap_id, trap.trap_id
FROM trap_routes
LEFT JOIN trap ON trap_routes.trap_id = trap.trap_id
WHERE trap.trap_ID IS NULL 
  • Query to update trap table using values from trap_routes table:
UPDATE trap, trap_routes 
SET trap.trap_route=trap_routes.trap_route, trap.trap_route_sequence=trap_routes.trap_route_sequence 
WHERE trap.trap_id=trap_routes.trap_id