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: : 168484
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168484'
The Shares Amount is 0
The cusip is 66573W206
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '66573W206'
Number of Rows :3
update current13Fpositions set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518' ,
percentOut = '0'
where entryId = '130736648'
update current13Fpositions set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518' ,
percentOut = '0'
where entryId = '100977918'
update current13Fpositions set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518' ,
percentOut = '0'
where entryId = '132545182'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '66573W206'
Number of Rows :122
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '98579483'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '98697031'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100480216'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99334546'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '98976943'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99458798'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99796186'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99806271'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100755815'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99259087'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99389766'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99477281'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100587480'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99025755'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '99464928'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100197413'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100228045'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100293416'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100324892'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100340490'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100341498'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100399687'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100400861'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100420576'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100462428'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100466788'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100539805'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100558060'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100422742'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '100465209'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '101172819'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102067579'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103055445'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102059716'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103230969'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102092058'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102077603'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102142092'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '101509641'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '101933121'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102187813'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102432571'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102455493'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102975098'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102570184'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102626819'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102641922'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102986055'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102987834'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102996498'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102996122'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102758959'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103003221'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102797890'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102962803'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103011558'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103013829'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '103121705'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '102669271'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '104053826'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '104444537'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '104552065'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105486466'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105012623'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105051360'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105491350'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105216494'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105510250'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105545572'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '105742208'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '106452906'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '106665713'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '107225689'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '107940536'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '107464096'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '108087971'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '107608474'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '107727596'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '108261168'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '109834746'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '110267491'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '109117923'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '109685699'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '110043333'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '110874047'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '110374644'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '110457312'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '111718552'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '111594448'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '112052688'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '111928338'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '112393524'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '113156467'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '113329016'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '113056972'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '114526769'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '114884993'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '114403272'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '115704604'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '115641631'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '116193348'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '115475578'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '114170393'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '118640713'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '116736897'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '118566099'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '116890766'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '118636830'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '118552257'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '116500181'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '120414468'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '120626388'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '120711972'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '122459678'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '122277532'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '123865047'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '125267757'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '124466176'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '126499794'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '127864456'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '129307042'
update archive13F set
compid = '168484',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834518'
where entryId = '128368504'
End Function
The Script is complete, exiting....