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: : 168225
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168225'
The Shares Amount is 0
The cusip is 67113Q204
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '67113Q204'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '67113Q204'
Number of Rows :122
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '96191573'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '96136569'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '96836578'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '96870495'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '96886114'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97053826'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97180615'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97190664'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97256105'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97386241'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97836785'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97698499'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97804579'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97830936'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97836475'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97868532'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97931167'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97967767'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97991981'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '97995951'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98017097'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98040633'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98050958'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98051381'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98056313'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98059045'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98107863'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98118076'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98497797'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '98829959'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99331157'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99166209'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99525365'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100655945'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99259388'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99390214'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100077089'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99477297'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99663922'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100093456'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99760061'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '99814848'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100626894'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100657187'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100623570'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100626421'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100630069'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100394933'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100643594'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100651985'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100645445'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100466814'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100476639'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100487025'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100648942'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100517085'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100650552'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100652534'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100184675'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '100846989'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102345423'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '101211155'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102383828'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102142407'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102316762'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102062141'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '101709894'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102188260'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102226663'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102736560'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102797916'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102808732'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '102849468'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '103007128'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '103096816'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '103116989'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104115347'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104054159'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104441714'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104514706'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105118834'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104795318'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '104941220'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105013176'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105086472'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105294028'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105304588'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105346223'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105524798'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '105160236'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107225308'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '106125268'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '106453251'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '106626500'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107388048'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107838579'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107572722'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '106543073'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107464721'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '107821968'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '108120619'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '108261258'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '108822608'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '109190086'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '110387191'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '109994022'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '110538231'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '110268085'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '109118267'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '109167066'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '109678737'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '110112648'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '110871021'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '111802781'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '111797256'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '113438669'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '112777327'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '112790331'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '112762197'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '112775395'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '113430986'
update archive13F set
compid = '168225',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821318'
where entryId = '113450292'
End Function
The Script is complete, exiting....