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: : 167145
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167145'
The Shares Amount is 9000000
The cusip is G9449A118
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G9449A118'
Number of Rows :11
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '230.76'
where entryId = '131748985'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '0.06'
where entryId = '132009553'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '44.47'
where entryId = '132055087'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '175.67'
where entryId = '132147104'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '0.23'
where entryId = '132248359'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '0.02'
where entryId = '131719734'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '53.99'
where entryId = '132095298'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '37.71'
where entryId = '132133052'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '0'
where entryId = '130478234'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '0'
where entryId = '100977965'
update current13Fpositions set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490' ,
percentOut = '112.62'
where entryId = '132056992'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G9449A118'
Number of Rows :139
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '96465006'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97011140'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '96888920'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97180679'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97190731'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97346075'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97283641'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97769416'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97996647'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '98001693'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '98046822'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '98049263'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '97823011'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '98579515'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100480835'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100844759'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '98927176'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '99261583'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100077394'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '99664752'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '99684255'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '99883007'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100266508'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100646464'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100478606'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100649700'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100527707'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '100613391'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '103230651'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102144760'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102317663'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102426532'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102331158'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102333685'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102583311'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '102811928'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '103009342'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '103224544'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '104056603'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '104442361'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105378309'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '104454295'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105016926'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105019085'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105162686'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105295770'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105303631'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '105160595'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107132888'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '106455833'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107746124'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107828300'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107838103'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107249247'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107468958'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107471397'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107785270'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '107700385'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '108261749'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '108823351'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110440380'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110272107'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '109120920'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110858098'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '109550963'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110039856'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '109681052'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110871518'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110274434'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '110107620'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '111595267'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '113364476'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '112059330'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '112345201'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '111931356'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '112245456'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '112944873'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '113143860'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '113171838'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '114527613'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '114888012'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '114407747'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '114571129'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '116078791'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '115071409'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '114553412'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '115421641'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '115423476'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '117155718'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '116608389'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '116895512'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '118142195'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '115943360'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '117767598'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '118095343'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '118059962'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '116503096'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '118058287'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '118260655'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120209788'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120195864'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '121402473'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120625395'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120714887'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '119672012'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120332124'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '121119366'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '120858504'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '121317779'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '121077195'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '121075667'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '122462633'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '122930500'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123976536'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123714950'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123463965'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '122865936'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123931739'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123817912'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123691532'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '123692974'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126152897'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '124469112'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '125762453'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126118230'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126216984'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126335605'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126898913'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '126900619'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '127867367'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '129316925'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '127585981'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '129173619'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '129143725'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '128723453'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '128452724'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '127981504'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '129141899'
update archive13F set
compid = '167145',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006490'
where entryId = '129222700'
End Function
The Script is complete, exiting....