Snippets

Lucas Possamai WM-250 - Review

Created by Lucas Possamai last modified
WM-250.sql
Raw 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SET TRANSACTION READ WRITE;
BEGIN TRANSACTION;

SELECT * 
INTO junk.ja_jobs_WM_250 FROM ja_jobs
WHERE status_label_id IN (577418,580105)
 AND ja_jobs.clientid = 27045
 ;;
UPDATE ja_jobs SET status_label_id = 577418 WHERE status_label_id = 580105;

COMMIT TRANSACTION;

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.