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: : 130661
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130661'
The Shares Amount is 3554000
The cusip is 81783K108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '81783K108'
Number of Rows :6
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '731.66'
where entryId = '42108597'
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '1096.89'
where entryId = '42176005'
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '1593.13'
where entryId = '42232240'
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '5.4'
where entryId = '51216220'
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '2.19'
where entryId = '65691840'
update current13Fpositions set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411' ,
percentOut = '0.96'
where entryId = '65721872'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '81783K108'
Number of Rows :85
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68287810'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67460028'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66465000'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67416938'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66993650'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67558709'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66645791'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67170077'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65491692'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66721990'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68073467'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68367886'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68361922'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66697047'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65259235'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67496900'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66900566'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66846421'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67039832'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67733686'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65751658'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67004622'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66125396'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65359979'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65815558'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65702248'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '66073123'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65561019'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65123867'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '63571100'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '63732768'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64226198'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64007179'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64114242'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64549622'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64759238'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64414383'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '63642883'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '63964261'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '63917714'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '65841550'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64194143'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64368611'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64918529'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64918065'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '64919701'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68493055'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69043206'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68811535'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68861386'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68887920'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67398030'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68754313'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69185518'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69176635'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69140708'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69315750'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69816632'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69939916'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69197571'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69611899'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68879555'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69977963'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69854126'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '69078261'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '67636974'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70508158'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70512967'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70854214'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70513875'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70512355'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71809667'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70858980'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71788149'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '73750691'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71740838'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '70690938'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71784383'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71754792'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71743438'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '71754040'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '68095264'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '81491294'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '51038361'
update archive13F set
compid = '130661',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0000825411'
where entryId = '96633894'
End Function
The Script is complete, exiting....