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: : 130963
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130963'
The Shares Amount is 30507000
The cusip is 73941U102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '73941U102'
Number of Rows :66
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '835.87'
where entryId = '1115369'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '1.71'
where entryId = '3506582'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '9.64'
where entryId = '3732714'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '32.78'
where entryId = '7188100'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.78'
where entryId = '9756654'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '33.08'
where entryId = '10246262'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '170.88'
where entryId = '11195093'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '5.1'
where entryId = '11197334'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '32.78'
where entryId = '11272425'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '12.73'
where entryId = '11424737'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '57.28'
where entryId = '12115656'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '199.94'
where entryId = '12269360'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '34.75'
where entryId = '12288417'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.03'
where entryId = '12319990'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.03'
where entryId = '12934803'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '4.87'
where entryId = '13244103'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '147.03'
where entryId = '13451397'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '56.56'
where entryId = '13615474'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '16.41'
where entryId = '13900405'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '197.47'
where entryId = '13923920'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.03'
where entryId = '13939247'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '14257513'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '5.05'
where entryId = '14328176'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '16.39'
where entryId = '14333041'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '14826271'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.12'
where entryId = '14877355'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '56.56'
where entryId = '15051626'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.33'
where entryId = '15158898'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '164.72'
where entryId = '15284359'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '147.06'
where entryId = '15761496'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '56.56'
where entryId = '16543726'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '164.69'
where entryId = '16822417'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '9.19'
where entryId = '16982892'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.68'
where entryId = '17016136'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '17074927'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '34.58'
where entryId = '17204803'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '5.49'
where entryId = '17419630'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '17770333'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '51.32'
where entryId = '18051171'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '9.19'
where entryId = '18177400'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '16.13'
where entryId = '23176226'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '24521964'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '24927440'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '1.74'
where entryId = '29137067'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '5.59'
where entryId = '29957047'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '39.9'
where entryId = '38324972'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '3.54'
where entryId = '38353446'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '2'
where entryId = '40851530'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '4.62'
where entryId = '41651983'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '3.68'
where entryId = '41675227'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '14.13'
where entryId = '42069847'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '15.36'
where entryId = '42106947'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '5.68'
where entryId = '42146653'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '80.5'
where entryId = '42172296'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '21.14'
where entryId = '42175019'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.98'
where entryId = '42197953'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0.24'
where entryId = '42203017'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '42264946'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '42266578'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '42267297'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '42466762'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '42469219'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '42.22'
where entryId = '47143607'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '4.54'
where entryId = '51215211'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '63.74'
where entryId = '59325876'
update current13Fpositions set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790' ,
percentOut = '0'
where entryId = '130460684'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '73941U102'
Number of Rows :24
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '77781908'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '79946113'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '81762285'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '83867575'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '86103148'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '87804185'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '90135549'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '92205558'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '94254639'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '51038134'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '96029198'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '96633671'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '98418100'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '100990133'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '103550582'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '105765417'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '109069087'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '111856367'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '114287862'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '116761848'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '119646988'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '122411066'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '124955861'
update archive13F set
compid = '130963',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001059790'
where entryId = '127817007'
End Function
The Script is complete, exiting....