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: : 130701
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130701'
The Shares Amount is 19380000
The cusip is 68375Q403
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '68375Q403'
Number of Rows :51
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '23.17'
where entryId = '2828014'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '9.84'
where entryId = '3732181'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '8.77'
where entryId = '4113249'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '4436332'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '6254161'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '8169460'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0.15'
where entryId = '9756380'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '374.96'
where entryId = '10244688'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '10874288'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '154.8'
where entryId = '12341375'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '11.17'
where entryId = '12847069'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '154.8'
where entryId = '13850743'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '11.17'
where entryId = '14231922'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '30.47'
where entryId = '14328035'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '14825898'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '1.83'
where entryId = '14876847'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '154.8'
where entryId = '15335512'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '15753347'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '11.32'
where entryId = '15775351'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '293.43'
where entryId = '16693564'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0.88'
where entryId = '17015977'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '12.08'
where entryId = '17045424'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '264.7'
where entryId = '18290895'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '12.08'
where entryId = '18383743'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '247.01'
where entryId = '19663780'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '252.42'
where entryId = '21351164'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '3.2'
where entryId = '22449360'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0.08'
where entryId = '23175412'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '24502046'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '24521733'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '24927323'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '29689149'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '4.51'
where entryId = '31799896'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '12.92'
where entryId = '32167017'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '6.98'
where entryId = '32908359'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '34254686'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '37.52'
where entryId = '39619709'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '9.29'
where entryId = '40851978'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '15.86'
where entryId = '42087178'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '17.12'
where entryId = '42106796'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '37.21'
where entryId = '42120774'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '6.73'
where entryId = '42146535'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '121.35'
where entryId = '42155699'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '1.39'
where entryId = '42158623'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '25.32'
where entryId = '42172225'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '334.47'
where entryId = '42219146'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '23.19'
where entryId = '42223056'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '8.71'
where entryId = '42225425'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '25.1'
where entryId = '46288643'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '45.1'
where entryId = '46539936'
update current13Fpositions set
compid = '130701',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001022225' ,
percentOut = '0'
where entryId = '51354556'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '68375Q403'
Number of Rows :0
End Function
The Script is complete, exiting....