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: : 145550
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '145550'
The Shares Amount is 0
The cusip is D12096109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'D12096109'
Number of Rows :3
update current13Fpositions set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '' ,
percentOut = '0'
where entryId = '39915015'
update current13Fpositions set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '' ,
percentOut = '0'
where entryId = '42459247'
update current13Fpositions set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '' ,
percentOut = '0'
where entryId = '42461373'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'D12096109'
Number of Rows :53
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '66265170'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '67212711'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '68378867'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '65872500'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '64975168'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '63805130'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '69949186'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '69516329'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '71593875'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '71164877'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '72731680'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '73179759'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '73340105'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '74061662'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '75048959'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '74850283'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '76611761'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '77047534'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '78142344'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '79495194'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '79816399'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '82101615'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '83947862'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '84951795'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '86543614'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '87225078'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '88061157'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '89726708'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '90539384'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '90369631'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '93856448'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '93790313'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '96257741'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '99366120'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '101231766'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '103046751'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '103764293'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '103979269'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '106981572'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '108773280'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '111407026'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '112064628'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '113846292'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '114410184'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '116691933'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '118550399'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '118832715'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '119060132'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '120857625'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '121561947'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '123506985'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '124293477'
update archive13F set
compid = '145550',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = ''
where entryId = '126791018'
End Function
The Script is complete, exiting....