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: : 167073
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167073'
The Shares Amount is 12500000
The cusip is G5859B125
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G5859B125'
Number of Rows :1
update current13Fpositions set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594' ,
percentOut = '0'
where entryId = '100652286'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G5859B125'
Number of Rows :155
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '94051635'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95276545'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '94459850'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '94649495'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '94868732'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '94912122'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95034424'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95293493'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95439209'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95485670'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95501300'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95789864'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95875485'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95894195'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95124767'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95386496'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95408337'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95476969'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95630943'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95758600'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95812473'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95813389'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95846490'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95860459'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95921609'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95939901'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95949125'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95950179'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '95959765'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96019213'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96191494'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98129105'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96225307'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96870466'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96884791'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97587325'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97076486'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97152916'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97256081'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97579389'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97323541'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97613039'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97386219'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97807139'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97836758'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98145894'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98085770'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98239516'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '96766520'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97283551'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97837091'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98160975'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97931074'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97932232'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98172719'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97996575'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98001816'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98178345'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98058440'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98065038'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98069486'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98086351'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98087317'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98118056'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98131317'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '98497721'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99149634'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99719379'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100480774'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99331118'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99562506'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100124624'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99493861'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100102477'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99258466'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99388851'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100077028'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99477223'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100091471'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '99663886'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100115877'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100096775'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100104942'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100610166'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100428784'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100657203'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100627056'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100637979'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100638246'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100467702'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100647456'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100652954'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100653702'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100562847'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100654747'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100469093'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100830843'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '103961846'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100600404'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '101509316'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102068577'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '103230413'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102141433'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102316718'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102186887'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102226532'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102453114'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102626204'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '102798888'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '103014440'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '103075257'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '101512453'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '100986101'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '103388393'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '104053149'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '104441666'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '105011457'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '105488898'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '105086354'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '105295116'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '105303942'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '104547850'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '106368699'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '107225197'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '106452198'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '107838254'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '108091010'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '108248434'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '108086553'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '107516751'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '107822984'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '110539218'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '109117207'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '109677892'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '110322171'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '113439032'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '112058931'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '111927611'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '112375986'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '112987193'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '114884258'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '114402081'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '115621465'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '97997988'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '115101456'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '117388879'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '116889498'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '116499465'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '118595112'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '118528457'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '120624824'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '120711256'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '120493055'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '123258133'
update archive13F set
compid = '167073',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001807594'
where entryId = '123945003'
End Function
The Script is complete, exiting....