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: : 158274
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '158274'
The Shares Amount is 206500000
The cusip is 16951E104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '16951E104'
Number of Rows :4
update current13Fpositions set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756' ,
percentOut = '26.06'
where entryId = '36402752'
update current13Fpositions set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756' ,
percentOut = '0.04'
where entryId = '51209099'
update current13Fpositions set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756' ,
percentOut = '1.11'
where entryId = '69269681'
update current13Fpositions set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756' ,
percentOut = '0'
where entryId = '73999310'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '16951E104'
Number of Rows :68
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66037208'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '67655820'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '67563716'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '67701032'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '68320923'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '68016333'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '67782458'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '67819621'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '68358131'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66656433'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66365266'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '65223836'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66274447'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66230198'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66943661'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66284616'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '65765302'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '65744730'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '66933220'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '65866296'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '65203356'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '63500476'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '63508423'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64316699'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64388387'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64269790'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64480616'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64539847'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64550761'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '64902441'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '68695936'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69123230'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69360722'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69522642'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69801631'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69877961'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69613862'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69201779'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '69979019'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '70132177'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '70291455'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '71650342'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '71208433'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '71749691'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '71188456'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '70933020'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '70996213'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72059776'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72162889'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72146699'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72812998'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72752144'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '72943654'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '73323064'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '73168678'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '73193205'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '73907301'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '74007346'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '75602517'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '75120526'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '75061031'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '74891434'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '74925324'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '77627574'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '77628832'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '77630402'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '77630380'
update archive13F set
compid = '158274',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001506756'
where entryId = '51108140'
End Function
The Script is complete, exiting....