To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 133502
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133502'
The Shares Amount is 124475000
The cusip is 38821G101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '38821G101'
Number of Rows :100
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '1359708'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '10.44'
where entryId = '1569770'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.01'
where entryId = '1827545'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '16.27'
where entryId = '2608253'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.98'
where entryId = '2827756'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '3.46'
where entryId = '2831878'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '21.24'
where entryId = '3031487'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '3190671'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '50.51'
where entryId = '3505088'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '3.75'
where entryId = '3673200'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '13.93'
where entryId = '3729513'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.02'
where entryId = '3846528'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.34'
where entryId = '3916986'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '19.55'
where entryId = '4113121'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.2'
where entryId = '4129410'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '9.64'
where entryId = '4374215'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '5099750'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '5581222'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.96'
where entryId = '6227894'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.32'
where entryId = '6910414'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.9'
where entryId = '7429831'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.06'
where entryId = '8273132'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.01'
where entryId = '9180325'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '77.53'
where entryId = '9227192'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '19.33'
where entryId = '9341474'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.99'
where entryId = '9625535'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.19'
where entryId = '9679626'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '13.89'
where entryId = '9754918'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '7.56'
where entryId = '10223272'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '182'
where entryId = '10236802'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.6'
where entryId = '10453489'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '17.73'
where entryId = '11034781'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.23'
where entryId = '11054909'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.32'
where entryId = '11077118'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '20.3'
where entryId = '11112407'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '15.97'
where entryId = '11179048'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '26'
where entryId = '11265104'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.45'
where entryId = '11289364'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '22.13'
where entryId = '11333735'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '4.56'
where entryId = '11449532'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.69'
where entryId = '12105344'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.76'
where entryId = '12170626'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.47'
where entryId = '12228529'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.54'
where entryId = '12271572'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.08'
where entryId = '12287248'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.82'
where entryId = '12318909'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '12326230'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '25.03'
where entryId = '12389543'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.03'
where entryId = '12417971'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.84'
where entryId = '12418171'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '12423984'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '12562609'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.45'
where entryId = '12598070'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.18'
where entryId = '12655358'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.4'
where entryId = '12709353'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.4'
where entryId = '12709762'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.75'
where entryId = '12778987'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '12790804'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '16.2'
where entryId = '12803986'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.41'
where entryId = '12811209'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '44.43'
where entryId = '12846118'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '22.53'
where entryId = '12888531'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.23'
where entryId = '12910749'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '2.57'
where entryId = '12925326'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '36.15'
where entryId = '12926635'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '6.25'
where entryId = '12934328'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '12987057'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.04'
where entryId = '13023338'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '20.01'
where entryId = '13151018'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '5.13'
where entryId = '13242670'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '15.43'
where entryId = '13443221'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.24'
where entryId = '13468670'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '13677544'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.02'
where entryId = '13847747'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '13857925'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.45'
where entryId = '13902467'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.91'
where entryId = '13917289'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.93'
where entryId = '13938171'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.72'
where entryId = '14073895'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.37'
where entryId = '14157269'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1'
where entryId = '14218385'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.42'
where entryId = '14218814'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.52'
where entryId = '14231030'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '4.89'
where entryId = '14310008'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '13.53'
where entryId = '14319806'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '20.93'
where entryId = '14327300'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '9.89'
where entryId = '14330618'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '14552595'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '19.6'
where entryId = '14613840'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.23'
where entryId = '14628709'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.28'
where entryId = '14661239'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0.04'
where entryId = '14678482'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '14823801'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '1.14'
where entryId = '14874495'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '15356470'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '16411362'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '16434450'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '16437893'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '18274076'
update current13Fpositions set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313' ,
percentOut = '0'
where entryId = '18355987'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '38821G101'
Number of Rows :1
update archive13F set
compid = '133502',
sectorNum = '901004',
sectorDes = 'Oil & Gas Equipment & Services',
issuerCik = '0001097313'
where entryId = '3847099'
End Function
The Script is complete, exiting....