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: : 168320
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168320'
The Shares Amount is 0
The cusip is 778673202
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '778673202'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '778673202'
Number of Rows :123
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96295731'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96285811'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97959903'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96510498'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96511353'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96870526'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '96887282'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97076557'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97145311'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97152947'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97161082'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97180638'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97190690'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97277144'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97324123'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97400513'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97474300'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97518459'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97836820'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97863076'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98017784'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98239217'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97144041'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97283565'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97443150'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97814485'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97830963'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97874841'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97891803'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97920763'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97930220'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97939251'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97939324'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97939535'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97939661'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97946415'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97958372'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97967798'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97996115'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97997854'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98017106'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98046800'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98107882'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98118098'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '97823105'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98630185'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98832217'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100480386'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99562612'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100110614'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99643959'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99820461'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100655908'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100844716'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '98982132'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99260332'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100077664'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100076954'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99477393'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99616059'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100091494'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100092338'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99684182'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100098578'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100069344'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100069481'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100111851'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100163877'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100612303'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100587668'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '99523965'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100128204'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100122872'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100294515'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100624678'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100626319'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100631031'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100632489'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100388735'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100637622'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100639696'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100639772'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100639891'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100639784'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100421127'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100429443'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100643588'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100467055'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100646639'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100477461'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100648962'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100649689'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100558168'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100613599'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '100465281'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102436943'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '103230602'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102143408'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102073081'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102438837'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102080131'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102189500'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102226812'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102455464'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102627924'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102671418'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102994231'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '103000094'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '103000812'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102798170'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102809690'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '103013736'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '103121871'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102427086'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '101512359'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '102449520'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '104803610'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105475005'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105489290'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105476019'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105493547'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105510376'
update archive13F set
compid = '168320',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001824403'
where entryId = '105510776'
End Function
The Script is complete, exiting....