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: : 168371
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168371'
The Shares Amount is 0
The cusip is 92280L200
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '92280L200'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '92280L200'
Number of Rows :124
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96136619'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96285816'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96510693'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96511405'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96836660'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96870580'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '96889388'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97076603'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97152975'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97180693'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97190738'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97239986'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97386282'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97822544'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97836874'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97854571'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98018009'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98239303'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98469114'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97283557'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97806438'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97807779'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97831015'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97868919'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97891843'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97931394'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97932702'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97947102'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97967830'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97996374'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98067076'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98104151'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98107910'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98118133'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '97823120'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98829888'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '98832221'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99331271'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99562697'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100130498'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100655979'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100844697'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99261875'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99393688'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100076964'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100116530'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100091491'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99664091'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100093394'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100094636'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99814919'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99892056'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99893401'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100587680'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100116420'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100128214'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100122905'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100623531'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100626532'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100630283'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100632466'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100637923'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100638154'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100421875'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100643579'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100467377'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '99526572'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100494991'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100550566'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100655430'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100624205'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '100469560'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '101211315'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102445634'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102383940'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102145073'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102316968'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102445446'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102191796'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102455456'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102760396'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102798537'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '102824281'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '103075156'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '103013177'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '103050855'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '101308122'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '104115537'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '104056917'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '104441935'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '104560903'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105017572'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105172915'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105217973'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105294758'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105383689'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105682289'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105707342'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '105622344'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '107225337'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '106125466'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '106456163'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '108075371'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '108121065'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '108237094'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '107469660'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '107648556'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '108100573'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '108104963'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '107822583'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '109190299'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '110538818'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '110272775'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '109121258'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '110408162'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '110107635'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '111802816'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '112057267'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '111931699'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '112775386'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '113472083'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '115958621'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '114773366'
update archive13F set
compid = '168371',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822145'
where entryId = '115943395'
End Function
The Script is complete, exiting....