Difference between revisions of "Technical Notes"

From Kbwiki
Jump to: navigation, search
Line 1: Line 1:
*Query to find unmatched <b>trap_id</b>'s:
+
*Query to find <b>trap_id</b>'s in the <b>trap_routes</b> table which are unmatched in the <b>trap</b> table:
  SELECT trap_routes.trap_id, trap.trap_id
+
  SELECT  
  FROM trap_routes
+
  trap_routes.trap_id, trap.trap_id
LEFT JOIN trap ON trap_routes.trap_id = trap.trap_id
+
  FROM  
  WHERE trap.trap_ID IS NULL  
+
  trap_routes LEFT JOIN trap ON trap_routes.trap_id = trap.trap_id
 +
  WHERE  
 +
  trap.trap_ID IS NULL  
  
 
* 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:

Revision as of 13:00, 16 January 2008

  • Query to find trap_id's in the trap_routes table which are unmatched in the trap table:
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