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: : 168449
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168449'
The Shares Amount is 9000000
The cusip is 77879W204
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '77879W204'
Number of Rows :2
update current13Fpositions set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681' ,
percentOut = '0'
where entryId = '102986657'
update current13Fpositions set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681' ,
percentOut = '77.37'
where entryId = '100539399'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '77879W204'
Number of Rows :151
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '98680037'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99719453'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99015620'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99331197'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99334543'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99562614'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99809605'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '98956263'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99120471'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99282446'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99480671'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99515961'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99517944'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99805909'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100452786'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99260340'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99391463'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99471128'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99477397'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99544275'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99606522'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99663979'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99814874'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99891834'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99893335'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99894051'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100163882'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100271153'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100587524'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99025855'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99465004'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99615899'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99620814'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100016682'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100228096'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100272714'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100294520'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100318387'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100336955'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100341587'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100385231'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100395040'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100396436'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100399726'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100413741'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100421129'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100449789'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100462500'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100467057'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '99526384'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100477463'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100485470'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100487067'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100488474'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100488752'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100494705'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100518413'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100539509'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100543998'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100549435'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100568495'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100569715'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100422767'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100465282'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100979764'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103961817'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100600458'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101367284'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102088012'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103074624'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102069135'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102450537'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101211208'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102445781'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102445654'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102383868'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103201368'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102143416'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102316835'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102967106'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101211844'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102432470'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102068134'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102445474'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102282782'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102078945'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102063083'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102059286'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101176377'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102434634'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101762129'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102069435'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102189503'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102226820'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102455487'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102570241'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102627929'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102965029'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102985313'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102671957'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102724145'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102995542'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102995277'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102996097'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102752281'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102759572'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102783985'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103003286'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102798173'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102809692'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103007027'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103007714'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103007775'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103008245'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103009019'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102875466'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102962761'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103011942'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103012149'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103015023'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103015183'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102973102'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103121348'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102981939'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102993030'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103013100'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103071827'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '101512232'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '102449949'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '100986113'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104793696'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104803608'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104831839'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104821712'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104804074'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '103969805'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104811517'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104795334'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105486442'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105475231'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105489776'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105476028'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105493693'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105499060'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105504314'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105505469'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105507860'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105510138'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105510775'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '105514336'
update archive13F set
compid = '168449',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826681'
where entryId = '104798098'
End Function
The Script is complete, exiting....