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: : 168260
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168260'
The Shares Amount is 20120000
The cusip is 88025V107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '88025V107'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '88025V107'
Number of Rows :145
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '98544234'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '98747123'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '98883279'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '98965096'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99011990'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99335095'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99561716'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99963831'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99458433'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100455518'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '98926836'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99252496'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99476669'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99664074'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99683788'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99902774'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99202661'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99669360'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99852358'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100016120'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100227767'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100287464'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100413301'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100417709'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100437904'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100469696'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100470833'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100486629'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100493211'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100519987'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100534620'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100539756'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100544252'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100573815'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '99778076'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100286980'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100469644'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100819986'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100755930'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100877028'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100915573'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '100969528'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101254233'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101426174'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102385326'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103055497'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101952041'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102135107'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102438119'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101598389'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102426536'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102439008'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101509687'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102174989'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102222389'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101503368'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102761056'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101600859'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102291752'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101502792'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101052482'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101667321'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101905614'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101978347'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102178723'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102225622'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102475045'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102569931'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102582653'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102620751'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102743876'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102747469'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102751511'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102751770'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102755729'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102777116'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102777306'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102801260'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102810513'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103008364'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102852477'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102875131'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102901727'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103010454'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102909037'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102921457'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102944290'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102945645'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103058729'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103060921'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103075735'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103227037'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '102683105'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103012851'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '101306998'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103291568'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103537976'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103709972'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103074027'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103968647'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103971109'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103535612'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104803639'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104804842'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104830111'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104831473'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104789319'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105523506'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104812650'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104813538'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104799232'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104788462'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105483411'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105524339'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105486440'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105475614'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105487055'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105489599'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105468397'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105476060'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105467136'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105502462'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105503587'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105504305'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105505957'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105507037'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105507203'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105470924'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105510522'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105523657'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105510665'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105525563'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105513475'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105514538'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105514997'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105516929'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105472446'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105517286'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105519180'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105519253'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105629402'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105757938'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '103711851'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '105504277'
update archive13F set
compid = '168260',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001821595'
where entryId = '104824194'
End Function
The Script is complete, exiting....