Skip to content

Instantly share code, notes, and snippets.

@gueroverde

gueroverde/para urbano

Created April 13, 2016 22:46
Show Gist options
  • Save gueroverde/4168fa5c06ab90ea0333f12078b1428d to your computer and use it in GitHub Desktop.
Save gueroverde/4168fa5c06ab90ea0333f12078b1428d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
para urbano
update tms_tracks set track = 'G5209552' where cod_rastreamento = '1000086703600' and track = '834.ecomerceG5209552';
update tms_tracks set track = 'G5209552' where cod_rastreamento = '1000086703600' and track = '834.ecomerceG5209552';
update tms_tracks set track = 'G5209560' where cod_rastreamento = '1000086703700' and track = '834.ecomerceG5209560';
update tms_tracks set track = 'G5198186' where cod_rastreamento = '1000086699300' and track = '834.ecomerceG5198186';
update tms_tracks set track = 'G5187486' where cod_rastreamento = '1000086673300' and track = '834.ecomerceG5187486';
update tms_tracks set track = 'G5218047' where cod_rastreamento = '1000086715100' and track = '834.ecomerceG5218047';
update tms_tracks set track = 'G5187842' where cod_rastreamento = '1000086666900' and track = '834.ecomerceG5187842';
update tms_tracks set track = 'G5209595' where cod_rastreamento = '1000086704000' and track = '834.ecomerceG5209595';
update tms_tracks set track = 'G5214203' where cod_rastreamento = '1000086706600' and track = '834.ecomerceG5214203';
update tms_tracks set track = 'G5194962' where cod_rastreamento = '1000086663100' and track = '834.ecomerceG5194962';
update tms_tracks set track = 'G5191459' where cod_rastreamento = '1000086682300' and track = '834.ecomerceG5191459';
update tms_tracks set track = 'G5194997' where cod_rastreamento = '1000086663500' and track = '834.ecomerceG5194997';
update tms_tracks set track = 'G5187494' where cod_rastreamento = '1000086669500' and track = '834.ecomerceG5187494';
update tms_tracks set track = 'G5217148' where cod_rastreamento = '1000086664100' and track = '834.ecomerceG5217148';
update tms_tracks set track = 'G5194989' where cod_rastreamento = '1000086663400' and track = '834.ecomerceG5194989';
update tms_tracks set track = 'G5191297' where cod_rastreamento = '1000086681100' and track = '834.ecomerceG5191297';
update tms_tracks set track = 'G5191149' where cod_rastreamento = '1000086652200' and track = '834.ecomerceG5191149';
update tms_tracks set track = 'G5217784' where cod_rastreamento = '1000086713500' and track = '834.ecomerceG5217784';
update tms_tracks set track = 'G5191416' where cod_rastreamento = '1000086682100' and track = '834.ecomerceG5191416';
update tms_tracks set track = 'G5188245' where cod_rastreamento = '1000086628600' and track = '834.ecomerceG5188245';
update tms_tracks set track = 'G5187753' where cod_rastreamento = '1000086651100' and track = '834.ecomerceG5187753';
update tms_tracks set track = 'G5187443' where cod_rastreamento = '1000086664000' and track = '834.ecomerceG5187443';
update tms_tracks set track = 'G5209587' where cod_rastreamento = '1000086703900' and track = '834.ecomerceG5209587';
update tms_tracks set track = 'G5217768' where cod_rastreamento = '1000086713300' and track = '834.ecomerceG5217768';
update tms_tracks set track = 'G5209609' where cod_rastreamento = '1000086704100' and track = '834.ecomerceG5209609';
update tms_tracks set track = 'G5217806' where cod_rastreamento = '1000086713700' and track = '834.ecomerceG5217806';
update tms_tracks set track = 'G5194784' where cod_rastreamento = '1000086693300' and track = '834.ecomerceG5194784';
update tms_tracks set track = 'G5195012' where cod_rastreamento = '1000086664400' and track = '834.ecomerceG5195012';
update tms_tracks set track = 'G5190851' where cod_rastreamento = '1000086651500' and track = '834.ecomerceG5190851';
update tms_tracks set track = 'G5209773' where cod_rastreamento = '1000086704600' and track = '834.ecomerceG5209773';
update tms_tracks set track = 'G5209730' where cod_rastreamento = '1000086704300' and track = '834.ecomerceG5209730';
update tms_tracks set track = 'G5195608' where cod_rastreamento = '1000086695400' and track = '834.ecomerceG5195608';
update tms_tracks set track = 'G5191408' where cod_rastreamento = '1000086681900' and track = '834.ecomerceG5191408';
update tms_tracks set track = 'G5209234' where cod_rastreamento = '1000086701300' and track = '834.ecomerceG5209234';
update tms_tracks set track = 'G5191041' where cod_rastreamento = '1000086652000' and track = '834.ecomerceG5191041';
update tms_tracks set track = 'G5188148' where cod_rastreamento = '1000086628500' and track = '834.ecomerceG5188148';
update tms_tracks set track = 'G5187354' where cod_rastreamento = '1000086642800' and track = '834.ecomerceG5187354';
update tms_tracks set track = 'G5216273' where cod_rastreamento = '1000086709700' and track = '834.ecomerceG5216273';
update tms_tracks set track = 'G5188431' where cod_rastreamento = '1000086628800' and track = '834.ecomerceG5188431';
update tms_tracks set track = 'G5209749' where cod_rastreamento = '1000086704400' and track = '834.ecomerceG5209749';
update tms_tracks set track = 'G5191033' where cod_rastreamento = '1000086651800' and track = '834.ecomerceG5191033';
update tms_tracks set track = 'G5187818' where cod_rastreamento = '1000086649900' and track = '834.ecomerceG5187818';
update tms_tracks set track = 'G5209722' where cod_rastreamento = '1000086704200' and track = '834.ecomerceG5209722';
update tms_tracks set track = 'G5187737' where cod_rastreamento = '1000086674400' and track = '834.ecomerceG5187737';
update tms_tracks set track = 'G5189306' where cod_rastreamento = '1000086643400' and track = '834.ecomerceG5189306';
update tms_tracks set track = 'G5189284' where cod_rastreamento = '1000086642500' and track = '834.ecomerceG5189284';
update tms_tracks set track = 'G5191157' where cod_rastreamento = '1000086652500' and track = '834.ecomerceG5191157';
update tms_tracks set track = 'G5217271' where cod_rastreamento = '1000086712400' and track = '834.ecomerceG5217271';
update tms_tracks set track = 'G5187796' where cod_rastreamento = '1000086650700' and track = '834.ecomerceG5187796';
update tms_tracks set track = 'G5191564' where cod_rastreamento = '1000086682800' and track = '834.ecomerceG5191564';
update tms_tracks set track = 'G5191564' where cod_rastreamento = '1000086682800' and track = '834.ecomerceG5191564';
update tms_tracks set track = 'G5191564' where cod_rastreamento = '1000086682800' and track = '834.ecomerceG5191564';
update tms_tracks set track = 'G5217792' where cod_rastreamento = '1000086713600' and track = '834.ecomerceG5217792';
update tms_tracks set track = 'G5191556' where cod_rastreamento = '1000086682400' and track = '834.ecomerceG5191556';
update tms_tracks set track = 'G5209412' where cod_rastreamento = '1000086703200' and track = '834.ecomerceG5209412';
update tms_tracks set track = 'G5187478' where cod_rastreamento = '1000086643000' and track = '834.ecomerceG5187478';
update tms_tracks set track = 'G5192838' where cod_rastreamento = '1000086687000' and track = '834.ecomerceG5192838';
update tms_tracks set track = 'G5192838' where cod_rastreamento = '1000086687000' and track = '834.ecomerceG5192838';
update tms_tracks set track = 'G5192838' where cod_rastreamento = '1000086687000' and track = '834.ecomerceG5192838';
update tms_tracks set track = 'G5192838' where cod_rastreamento = '1000086687000' and track = '834.ecomerceG5192838';
update tms_tracks set track = 'G5192854' where cod_rastreamento = '1000086687300' and track = '834.ecomerceG5192854';
update tms_tracks set track = 'G5209269' where cod_rastreamento = '1000086701500' and track = '834.ecomerceG5209269';
update tms_tracks set track = 'G5188253' where cod_rastreamento = '1000086628700' and track = '834.ecomerceG5188253';
update tms_tracks set track = 'G5189276' where cod_rastreamento = '1000086642400' and track = '834.ecomerceG5189276';
update tms_tracks set track = 'G5191777' where cod_rastreamento = '1000086667000' and track = '834.ecomerceG5191777';
update tms_tracks set track = 'G5189292' where cod_rastreamento = '1000086642600' and track = '834.ecomerceG5189292';
update tms_tracks set track = 'G5193605' where cod_rastreamento = '1000086651200' and track = '834.ecomerceG5193605';
update tms_tracks set track = 'G5187771' where cod_rastreamento = '1000086674300' and track = '834.ecomerceG5187771';
update tms_tracks set track = 'G5196353' where cod_rastreamento = '1000086654600' and track = '834.ecomerceG5196353';
update tms_tracks set track = 'G5188369' where cod_rastreamento = '1000086638800' and track = '834.ecomerceG5188369';
update tms_tracks set track = 'G5191270' where cod_rastreamento = '1000086680400' and track = '834.ecomerceG5191270';
update tms_tracks set track = 'G5188369' where cod_rastreamento = '1000086638800' and track = '834.ecomerceG5188369';
update tms_tracks set track = 'G5190843' where cod_rastreamento = '1000086679400' and track = '834.ecomerceG5190843';
update tms_tracks set track = 'G5196426' where cod_rastreamento = '1000086669300' and track = '834.ecomerceG5196426';
update tms_tracks set track = 'G5192846' where cod_rastreamento = '1000086687100' and track = '834.ecomerceG5192846';
update tms_tracks set track = 'G5216281' where cod_rastreamento = '1000086709800' and track = '834.ecomerceG5216281';
update tms_tracks set track = 'G5187567' where cod_rastreamento = '1000086663200' and track = '834.ecomerceG5187567';
update tms_tracks set track = 'G5187826' where cod_rastreamento = '1000086650000' and track = '834.ecomerceG5187826';
update tms_tracks set track = 'G5187826' where cod_rastreamento = '1000086650000' and track = '834.ecomerceG5187826';
update tms_tracks set track = 'G5217776' where cod_rastreamento = '1000086713400' and track = '834.ecomerceG5217776';
update tms_tracks set track = 'G5192821' where cod_rastreamento = '1000086686800' and track = '834.ecomerceG5192821';
update tms_tracks set track = 'G5188458' where cod_rastreamento = '1000086675600' and track = '834.ecomerceG5188458';
update tms_tracks set track = 'G5192791' where cod_rastreamento = '1000086650500' and track = '834.ecomerceG5192791';
update tms_tracks set track = 'G5192791' where cod_rastreamento = '1000086650500' and track = '834.ecomerceG5192791';
update tms_tracks set track = 'G5192791' where cod_rastreamento = '1000086650500' and track = '834.ecomerceG5192791';
update tms_tracks set track = 'G5192791' where cod_rastreamento = '1000086650500' and track = '834.ecomerceG5192791';
update tms_tracks set track = 'G5194814' where cod_rastreamento = '1000086692400' and track = '834.ecomerceG5194814';
update tms_tracks set track = 'G5218039' where cod_rastreamento = '1000086715000' and track = '834.ecomerceG5218039';
update tms_tracks set track = 'G5192862' where cod_rastreamento = '1000086687500' and track = '834.ecomerceG5192862';
update tms_tracks set track = 'G5192862' where cod_rastreamento = '1000086687500' and track = '834.ecomerceG5192862';
update tms_tracks set track = 'G5195047' where cod_rastreamento = '1000086694500' and track = '834.ecomerceG5195047';
update tms_tracks set track = 'G5198291' where cod_rastreamento = '1000086642000' and track = '834.ecomerceG5198291';
update tms_tracks set track = 'G5187451' where cod_rastreamento = '1000086673000' and track = '834.ecomerceG5187451';
update tms_tracks set track = 'G5187451' where cod_rastreamento = '1000086673000' and track = '834.ecomerceG5187451';
update tms_tracks set track = 'G5189268' where cod_rastreamento = '1000086642300' and track = '834.ecomerceG5189268';
update tms_tracks set track = 'G5209250' where cod_rastreamento = '1000086701400' and track = '834.ecomerceG5209250';
update tms_tracks set track = 'G5187370' where cod_rastreamento = '1000086665700' and track = '834.ecomerceG5187370';
update tms_tracks set track = 'G5189578' where cod_rastreamento = '1000086662500' and track = '834.ecomerceG5189578';
update tms_tracks set track = 'G5188441' where cod_rastreamento = '1000086675500' and track = '834.ecomerceG5188441';
update tms_tracks set track = 'G5195020' where cod_rastreamento = '1000086664500' and track = '834.ecomerceG5195020';
update tms_tracks set track = 'G5194830' where cod_rastreamento = '1000086692600' and track = '834.ecomerceG5194830';
update tms_tracks set track = 'G5194921' where cod_rastreamento = '1000086694200' and track = '834.ecomerceG5194921';
update tms_tracks set track = 'G5187461' where cod_rastreamento = '1000086654900' and track = '834.ecomerceG5187461';
update tms_tracks set track = 'G5193435' where cod_rastreamento = '1000086689200' and track = '834.ecomerceG5193435';
update tms_tracks set track = 'G5216982' where cod_rastreamento = '1000086684300' and track = '834.ecomerceG5216982';
update tms_tracks set track = 'G5194873' where cod_rastreamento = '1000086693600' and track = '834.ecomerceG5194873';
update tms_tracks set track = 'G5194865' where cod_rastreamento = '1000086692900' and track = '834.ecomerceG5194865';
update tms_tracks set track = 'G5216494' where cod_rastreamento = '1000086710100' and track = '834.ecomerceG5216494';
update tms_tracks set track = 'G5198275' where cod_rastreamento = '1000086642200' and track = '834.ecomerceG5198275';
update tms_tracks set track = 'G5193621' where cod_rastreamento = '1000086690000' and track = '834.ecomerceG5193621';
update tms_tracks set track = 'G5189977' where cod_rastreamento = '1000086678800' and track = '834.ecomerceG5189977';
update tms_tracks set track = 'G5194849' where cod_rastreamento = '1000086692700' and track = '834.ecomerceG5194849';
update tms_tracks set track = 'G5198380' where cod_rastreamento = '1000086700100' and track = '834.ecomerceG5198380';
update tms_tracks set track = 'G5188377' where cod_rastreamento = '1000086665600' and track = '834.ecomerceG5188377';
update tms_tracks set track = 'G5195284' where cod_rastreamento = '1000086694900' and track = '834.ecomerceG5195284';
update tms_tracks set track = 'G5194857' where cod_rastreamento = '1000086692800' and track = '834.ecomerceG5194857';
update tms_tracks set track = 'G5193672' where cod_rastreamento = '1000086671700' and track = '834.ecomerceG5193672';
update tms_tracks set track = 'G5187672' where cod_rastreamento = '1000086666300' and track = '834.ecomerceG5187672';
update tms_tracks set track = 'G5195578' where cod_rastreamento = '1000086695200' and track = '834.ecomerceG5195578';
update tms_tracks set track = 'G5195586' where cod_rastreamento = '1000086695300' and track = '834.ecomerceG5195586';
update tms_tracks set track = 'G5189047' where cod_rastreamento = '1000086675900' and track = '834.ecomerceG5189047';
update tms_tracks set track = 'G5191130' where cod_rastreamento = '1000086680000' and track = '834.ecomerceG5191130';
update tms_tracks set track = 'G5187516' where cod_rastreamento = '1000086671000' and track = '834.ecomerceG5187516';
update tms_tracks set track = 'G5189411' where cod_rastreamento = '1000086659800' and track = '834.ecomerceG5189411';
update tms_tracks set track = 'G5217113' where cod_rastreamento = '1000086712000' and track = '834.ecomerceG5217113';
update tms_tracks set track = 'G5188156' where cod_rastreamento = '1000086674700' and track = '834.ecomerceG5188156';
update tms_tracks set track = 'G5199115' where cod_rastreamento = '1000086686200' and track = '834.ecomerceG5199115';
update tms_tracks set track = 'G5198437' where cod_rastreamento = '1000086700400' and track = '834.ecomerceG5198437';
update tms_tracks set track = 'G5187321' where cod_rastreamento = '1000086654800' and track = '834.ecomerceG5187321';
update tms_tracks set track = 'G5194806' where cod_rastreamento = '1000086693500' and track = '834.ecomerceG5194806';
update tms_tracks set track = 'G5194822' where cod_rastreamento = '1000086692500' and track = '834.ecomerceG5194822';
update tms_tracks set track = 'G5189616' where cod_rastreamento = '1000086678600' and track = '834.ecomerceG5189616';
update tms_tracks set track = 'G5217301' where cod_rastreamento = '1000086712600' and track = '834.ecomerceG5217301';
update tms_tracks set track = 'G5191572' where cod_rastreamento = '1000086682900' and track = '834.ecomerceG5191572';
update tms_tracks set track = 'G5191289' where cod_rastreamento = '1000086681000' and track = '834.ecomerceG5191289';
update tms_tracks set track = 'G5217814' where cod_rastreamento = '1000086713900' and track = '834.ecomerceG5217814';
update tms_tracks set track = 'G5216621' where cod_rastreamento = '1000086711000' and track = '834.ecomerceG5216621';
update tms_tracks set track = 'G5188164' where cod_rastreamento = '1000086672200' and track = '834.ecomerceG5188164';
update tms_tracks set track = 'G5189969' where cod_rastreamento = '1000086678700' and track = '834.ecomerceG5189969';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment