<select>
<option value="AL">Albania</option><option value="DZ">Algeria</option><option value="AD">Andorra</option><option value="AO">Angola</option><option value="AI">Anguilla</option><option value="AG">Antigua & Barbuda</option><option value="AR">Argentina</option><option value="AM">Armenia</option><option value="AW">Aruba</option><option value="AU">Australia</option><option value="AT">Austria</option><option value="AZ">Azerbaijan</option><option value="BS">Bahamas</option><option value="BH">Bahrain</option><option value="BB">Barbados</option><option value="BY">Belarus</option><option value="BE">Belgium</option><option value="BZ">Belize</option><option value="BJ">Benin</option><option value="BM">Bermuda</option><option value="BT">Bhutan</option><option value="BO">Bolivia</option><option value="BA">Bosnia & Herzegovina</option><option value="BW">Botswana</option><option value="BR">Brazil</option><option value="VG">British Virgin Islands</option><option value="BN">Brunei</option><option value="BG">Bulgaria</option><option value="BF">Burkina Faso</option><option value="BI">Burundi</option><option value="KH">Cambodia</option><option value="CM">Cameroon</option><option value="CA">Canada</option><option value="CV">Cape Verde</option><option value="KY">Cayman Islands</option><option value="TD">Chad</option><option value="CL">Chile</option><option value="C2">China</option><option value="CO">Colombia</option><option value="KM">Comoros</option><option value="CG">Congo - Brazzaville</option><option value="CD">Congo - Kinshasa</option><option value="CK">Cook Islands</option><option value="CR">Costa Rica</option><option value="CI">Côte d’Ivoire</option><option value="HR">Croatia</option><option value="CY">Cyprus</option><option value="CZ">Czech Republic</option><option value="DK">Denmark</option><option value="DJ">Djibouti</option><option value="DM">Dominica</option><option value="DO">Dominican Republic</option><option value="EC">Ecuador</option><option value="EG">Egypt</option><option value="SV">El Salvador</option><option value="ER">Eritrea</option><option value="EE">Estonia</option><option value="ET">Ethiopia</option><option value="FK">Falkland Islands</option><option value="FO">Faroe Islands</option><option value="FJ">Fiji</option><option value="FI">Finland</option><option value="FR">France</option><option value="GF">French Guiana</option><option value="PF">French Polynesia</option><option value="GA">Gabon</option><option value="GM">Gambia</option><option value="GE">Georgia</option><option value="DE">Germany</option><option value="GI">Gibraltar</option><option value="GR">Greece</option><option value="GL">Greenland</option><option value="GD">Grenada</option><option value="GP">Guadeloupe</option><option value="GT">Guatemala</option><option value="GN">Guinea</option><option value="GW">Guinea-Bissau</option><option value="GY">Guyana</option><option value="HN">Honduras</option><option value="HK">Hong Kong SAR China</option><option value="HU">Hungary</option><option value="IS">Iceland</option><option value="IN">India</option><option value="ID">Indonesia</option><option value="IE">Ireland</option><option value="IL">Israel</option><option value="IT">Italy</option><option value="JM">Jamaica</option><option value="JP">Japan</option><option value="JO">Jordan</option><option value="KZ">Kazakhstan</option><option value="KE">Kenya</option><option value="KI">Kiribati</option><option value="KW">Kuwait</option><option value="KG">Kyrgyzstan</option><option value="LA">Laos</option><option value="LV">Latvia</option><option value="LS">Lesotho</option><option value="LI">Liechtenstein</option><option value="LT">Lithuania</option><option value="LU">Luxembourg</option><option value="MK">Macedonia</option><option value="MG">Madagascar</option><option value="MW">Malawi</option><option value="MY">Malaysia</option><option value="MV">Maldives</option><option value="ML">Mali</option><option value="MT">Malta</option><option value="MH">Marshall Islands</option><option value="MQ">Martinique</option><option value="MR">Mauritania</option><option value="MU">Mauritius</option><option value="YT">Mayotte</option><option value="MX">Mexico</option><option value="FM">Micronesia</option><option value="MD">Moldova</option><option value="MC">Monaco</option><option value="MN">Mongolia</option><option value="ME">Montenegro</option><option value="MS">Montserrat</option><option value="MA">Morocco</option><option value="MZ">Mozambique</option><option value="NA">Namibia</option><option value="NR">Nauru</option><option value="NP">Nepal</option><option value="NL">Netherlands</option><option value="AN">Netherlands Antilles</option><option value="NC">New Caledonia</option><option value="NZ">New Zealand</option><option value="NI">Nicaragua</option><option value="NE">Niger</option><option value="NG">Nigeria</option><option value="NU">Niue</option><option value="NF">Norfolk Island</option><option value="NO">Norway</option><option value="OM">Oman</option><option value="PW">Palau</option><option value="PA">Panama</option><option value="PG">Papua New Guinea</option><option value="PY">Paraguay</option><option value="PE">Peru</option><option value="PH">Philippines</option><option value="PN">Pitcairn Islands</option><option value="PL">Poland</option><option value="PT">Portugal</option><option value="QA">Qatar</option><option value="RE">Réunion</option><option value="RO">Romania</option><option value="RU">Russia</option><option value="RW">Rwanda</option><option value="WS">Samoa</option><option value="SM">San Marino</option><option value="ST">São Tomé & Príncipe</option><option value="SA">Saudi Arabia</option><option value="SN">Senegal</option><option value="RS">Serbia</option><option value="SC">Seychelles</option><option value="SL">Sierra Leone</option><option value="SG">Singapore</option><option value="SK">Slovakia</option><option value="SI">Slovenia</option><option value="SB">Solomon Islands</option><option value="SO">Somalia</option><option value="ZA">South Africa</option><option value="KR">South Korea</option><option value="ES">Spain</option><option value="LK">Sri Lanka</option><option value="SH">St. Helena</option><option value="KN">St. Kitts & Nevis</option><option value="LC">St. Lucia</option><option value="PM">St. Pierre & Miquelon</option><option value="VC">St. Vincent & Grenadines</option><option value="SR">Suriname</option><option value="SJ">Svalbard & Jan Mayen</option><option value="SZ">Swaziland</option><option value="SE">Sweden</option><option value="CH">Switzerland</option><option value="TW">Taiwan</option><option value="TJ">Tajikistan</option><option value="TZ">Tanzania</option><option value="TH">Thailand</option><option value="TG">Togo</option><option value="TO">Tonga</option><option value="TT">Trinidad & Tobago</option><option value="TN">Tunisia</option><option value="TR">Turkey</option><option value="TM">Turkmenistan</option><option value="TC">Turks & Caicos Islands</option><option value="TV">Tuvalu</option><option value="UG">Uganda</option><option value="UA">Ukraine</option><option value="AE">United Arab Emirates</option><option value="GB">United Kingdom</option><option value="US">United States</option><option value="UY">Uruguay</option><option value="VU">Vanuatu</option><option value="VA">Vatican City</option><option value="VE">Venezuela</option><option value="VN">Vietnam</option><option value="WF">Wallis & Futuna</option><option value="YE">Yemen</option><option value="ZM">Zambia</option><option value="ZW">Zimbabwe</option></select>
Monday 30 September 2019
Wednesday 25 September 2019
AWS S3 File upload using php sdk
Working example Example :
<?php
set_include_path(".:/home/whyceffy/public_html/fam/lib");
require 'aws/autoloader.php';
use Aws\S3\S3Client;
use Aws\Exception\AwsException;
echo '<form action="https://whyceeyes.com/fam/test.php" method="post" enctype="multipart/form-data"> <input type="FILE" name="filetoupload"><input type="submit" name="submit" value="Upload Now"></form>';
function handle_file_upload($params, $userID = NULL) {
try{
//Create a S3Client
$s3 = new S3Client(array(
//'profile' => 'default', donot use this if credential user here below
'region' => 'ap-southeast-1',
'version' => '2006-03-01',
'credentials' => array(
'key' => 'Access key ID of IAM',
'secret' => 'this password from users secret'
)
));
if (empty($_FILES)) {
return false;
}
if (!is_uploaded_file($_FILES[$params]['tmp_name'])) {
return false;
}
$sourcePath = $_FILES[$params]['tmp_name'];
$bucket = 'mefm';
$keyname = 'resource/' . $userID . '-' . date('y-m-d-H-i-s') . '-' . $_FILES[$params]['name'];
$result = $s3->putObject([
'Bucket' => $bucket,
'Key' => $keyname,
'ACL' => 'public-read',
'//Body' => 'Hello, world!',
'SourceFile' =>$sourcePath,
]);
if($result["@metadata"]["statusCode"] === 200){
return $result['ObjectURL'];
}else{
return false;
}
} catch (S3Exception $e) {
return false;
}
}
$s3url = handle_file_upload("filetoupload",'me');
if($s3url){
echo $s3url;
}
===============================
if key is not properly defined
in
$result = $s3->putObject([
'Bucket' => $bucket,
'Key' => $keyname,
'ACL' => 'public-read',
'//Body' => 'Hello, world!',
'SourceFile' =>$sourcePath,
]);
then
PHP Fatal error: Uncaught exception 'InvalidArgumentException' with message 'Found 1 error while validating the input provided for the PutObject operation:
[Key] is missing and is a required parameter' in /home/public_html/fam/lib/aws/Aws/Api/Validator.php:65
Stack trace:
===================================
<?php
set_include_path(".:/home/whyceffy/public_html/fam/lib");
require 'aws/autoloader.php';
use Aws\S3\S3Client;
use Aws\Exception\AwsException;
echo '<form action="https://whyceeyes.com/fam/test.php" method="post" enctype="multipart/form-data"> <input type="FILE" name="filetoupload"><input type="submit" name="submit" value="Upload Now"></form>';
function handle_file_upload($params, $userID = NULL) {
try{
//Create a S3Client
$s3 = new S3Client(array(
//'profile' => 'default', donot use this if credential user here below
'region' => 'ap-southeast-1',
'version' => '2006-03-01',
'credentials' => array(
'key' => 'Access key ID of IAM',
'secret' => 'this password from users secret'
)
));
if (empty($_FILES)) {
return false;
}
if (!is_uploaded_file($_FILES[$params]['tmp_name'])) {
return false;
}
$sourcePath = $_FILES[$params]['tmp_name'];
$bucket = 'mefm';
$keyname = 'resource/' . $userID . '-' . date('y-m-d-H-i-s') . '-' . $_FILES[$params]['name'];
$result = $s3->putObject([
'Bucket' => $bucket,
'Key' => $keyname,
'ACL' => 'public-read',
'//Body' => 'Hello, world!',
'SourceFile' =>$sourcePath,
]);
if($result["@metadata"]["statusCode"] === 200){
return $result['ObjectURL'];
}else{
return false;
}
} catch (S3Exception $e) {
return false;
}
}
$s3url = handle_file_upload("filetoupload",'me');
if($s3url){
echo $s3url;
}
===============================
if key is not properly defined
in
$result = $s3->putObject([
'Bucket' => $bucket,
'Key' => $keyname,
'ACL' => 'public-read',
'//Body' => 'Hello, world!',
'SourceFile' =>$sourcePath,
]);
then
PHP Fatal error: Uncaught exception 'InvalidArgumentException' with message 'Found 1 error while validating the input provided for the PutObject operation:
[Key] is missing and is a required parameter' in /home/public_html/fam/lib/aws/Aws/Api/Validator.php:65
Stack trace:
===================================
Saturday 21 September 2019
SQL JOIN example
EXPLAIN
SELECT
p.ID,
p.entity_ID entity_ID,
p.product_type,
p.product_name,
p.product_keyword,
p.order_qty_min AS qmn,
p.pref_selling_price AS sp,
p.country,
p.state,
p.product_category,
p.Shipping_from,
p.selling_price_max AS maxSellingPrice,
p.selling_price_min AS minSellingPrice,
pp.order_qty_price AS sp,
pp.order_qty_unit AS ou,
pp.order_qty_max AS qmx,
pp.order_qty_min AS qmn,
AVG(r.rating) AS productRating,
c.company_name AS Title,
c.about_company AS Description,
c.contact_email AS Email,
c.ID AS sellerID,
c.company_city,
c.countryid
FROM
product AS p
LEFT JOIN product_rating AS r
ON
p.ID = r.product_id
LEFT JOIN \company AS c
ON
p.entity_ID = c.entity_ID
LEFT JOIN product_price_detail AS pp
ON
pp.products_id = p.ID
WHERE
p.ID = 'Prod5d84a4f8af065'
GROUP BY
p.ID
SELECT
p.ID,
p.entity_ID entity_ID,
p.product_type,
p.product_name,
p.product_keyword,
p.order_qty_min AS qmn,
p.pref_selling_price AS sp,
p.country,
p.state,
p.product_category,
p.Shipping_from,
p.selling_price_max AS maxSellingPrice,
p.selling_price_min AS minSellingPrice,
pp.order_qty_price AS sp,
pp.order_qty_unit AS ou,
pp.order_qty_max AS qmx,
pp.order_qty_min AS qmn,
AVG(r.rating) AS productRating,
c.company_name AS Title,
c.about_company AS Description,
c.contact_email AS Email,
c.ID AS sellerID,
c.company_city,
c.countryid
FROM
product AS p
LEFT JOIN product_rating AS r
ON
p.ID = r.product_id
LEFT JOIN \company AS c
ON
p.entity_ID = c.entity_ID
LEFT JOIN product_price_detail AS pp
ON
pp.products_id = p.ID
WHERE
p.ID = 'Prod5d84a4f8af065'
GROUP BY
p.ID
subquery with multiple columns value comparison
REF:
http://download.nust.na/pub6/mysql/tech-resources/articles/4.1/subqueries.html
Example:
compcolum : Return 0 if not matches or return 1 if matches
Other Uses of Subqueries
The SQL Standard, effective with SQL:1999, requires increased subquery support, which MySQL provides. The row subqueries alluded to earlier are an example. Thus, it is now possible to compare multiple columns at a time:SELECT ROW ('smith', 'auditor') =
(SELECT lname, job FROM clients WHERE clno = 10);
The subquery in this example returns a row containing the values
'smith' and 'auditor'. When these values are compared
to the ROW values in the outer query, they are found to be equal
and so the query returns 1 (true).http://download.nust.na/pub6/mysql/tech-resources/articles/4.1/subqueries.html
Example:
SELECT p.ID, p.entity_ID entity_ID,
p.product_type, p.product_name, p.product_keyword,
p.listing_desc,p.product_desc,p.industry_type,p.product_subcategory,
p.brand_name,p.contact_country,p.industry_type, p.product_subcategory,
p.order_unit, p.order_qty_max, p.order_qty_min, p.pref_selling_price,
p.country, p.state,p.product_category,p.Shipping_from,
p.selling_price_max as maxSellingPrice, p.selling_price_min as
minSellingPrice,
ROW ('pref_selling_price', 'order_unit') = (SELECT order_qty_price, pp.order_qty_unit FROM product_price_detail as pp WHERE pp.products_id = 'Prod5d84a4f8af065' LIMIT 1) as compcolum,
AVG(r.rating) as productRating,c.company_name as Title, c.about_company as Description, c.contact_email as Email, c.ID as sellerID, c.company_city, c.countryid FROM product as p LEFT JOIN product_rating as r ON p.ID = r.product_id LEFT JOIN company as c ON p.entity_ID = c.entity_ID LEFT JOIN product_price_detail as ppt ON ppt.products_id = p.ID WHERE p.ID = '[...]
ROW ('pref_selling_price', 'order_unit') = (SELECT order_qty_price, pp.order_qty_unit FROM product_price_detail as pp WHERE pp.products_id = 'Prod5d84a4f8af065' LIMIT 1) as compcolum,
AVG(r.rating) as productRating,c.company_name as Title, c.about_company as Description, c.contact_email as Email, c.ID as sellerID, c.company_city, c.countryid FROM product as p LEFT JOIN product_rating as r ON p.ID = r.product_id LEFT JOIN company as c ON p.entity_ID = c.entity_ID LEFT JOIN product_price_detail as ppt ON ppt.products_id = p.ID WHERE p.ID = '[...]
compcolum : Return 0 if not matches or return 1 if matches
Wednesday 18 September 2019
business category sql
CREATE TABLE `business_category` (
`ID` int(11) NOT NULL,
`patent_business_category_ID` int(11) NOT NULL,
`title` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='business or industry category';
INSERT INTO `business_category` (`ID`, `patent_business_category_ID`, `title`) VALUES
(11, 0, 'Agriculture, Forestry, Fishing & Hunting'),
(21, 0, 'Mining'),
(22, 0, 'Utilities'),
(52, 0, 'Finance and Insurance'),
(23, 0, 'Construction'),
(31, 0, 'Manufacturing'),
(42, 0, 'Wholesale Trade'),
(44, 0, 'Retail Trade'),
(48, 0, 'Transportation and Warehousing'),
(51, 0, 'Information'),
(53, 0, ' Real Estate and Rental and Leasing'),
(54, 0, 'Professional, Scientific and Technical Services'),
(55, 0, ' Management of Companies and Enterprises'),
(56, 0, 'Administrative and Support and Waste Management'),
(61, 0, ' Educational Services'),
(99, 0, ' Central Administrative Office Activity'),
(81, 0, ' Other Services (except Public Administration)'),
(72, 0, 'Accomodation and Food Services'),
(71, 0, 'Arts, Entertainment and Recreation'),
(62, 0, 'Health Care and Social Assistance'),
(1110, 11, 'Crop and Animal Production'),
(1130, 11, 'Forestry, Logging, Fishing, Hunting, Trapping and Agricultural Support Activities'),
(2110, 21, 'Oil and Gas Extraction'),
(2121, 21, 'Coal Mining'),
(2122, 21, 'Metal Ore Mining'),
(2123, 21, 'Nonmetallic Mineral Mining and Quarrying'),
(2130, 21, 'Support Activities for Oil and Gas Operations'),
(2131, 21, 'Support Activities for Solid Mineral Operations'),
(2211, 22, 'Electric Power Generation, Transmission and Distribution'),
(2212, 22, 'Natural Gas Distribution'),
(2213, 22, 'Water, Sewage and Other Systems'),
(2360, 23, 'Construction of Buildings'),
(2370, 23, 'Heavy and Civil Engineering Construction'),
(2380, 23, 'Specialty Trade Contractors'),
(3121, 31, 'Beverage Manufacturing'),
(3122, 31, 'Tobacco Manufacturing'),
(3130, 31, 'Textile Mills and Textile Product Mills'),
(3150, 31, 'Apparel Manufacturing'),
(3160, 31, 'Leather and Allied Product Manufacturing'),
(3210, 31, 'Wood Product Manufacturing'),
(3220, 31, 'Paper Manufacturing'),
(3230, 21, 'Printing and Related Support Activities'),
(3240, 31, 'Petroleum and Coal Products Manufacturing'),
(3251, 31, 'Basic Chemical, Resin, Synthetic Rubber and Fiber Manufactuing'),
(3253, 31, 'Pesticide, Fertilizer and Other Agricultural Chemical Manufacturing'),
(3254, 31, 'Pharmaceutical and Medicine Manufacturing'),
(3259, 31, 'Paint, Adhesive, Soap and Other Chemical Manufacturing'),
(3260, 31, 'Plastics and Rubber Products Manufacturing (except inflatable boats)'),
(3271, 31, 'Clay and Glass Products Manufacturing'),
(3279, 31, 'Cement, Concrete, Lime, Gypsum and Other Nonmetallic Mineral Product Manufacturing'),
(3311, 31, 'Iron and Steel Mills, Ferroalloy Manufacturing and Steel Product Manufacturing from Purchased Steel'),
(3313, 31, 'Nonferrous Metals Production and Processing'),
(3315, 31, 'Ferrous and Nonferrous Foundries'),
(3320, 31, 'Fabricated Metal Product Manufacturing'),
(3331, 31, 'Agriculture, Construction and Mining Machinery Manufacturing'),
(3332, 31, 'Industrial, Metalworking and General Purpose Machinery Manufacturing (Including Laboratory Apparatus)'),
(3333, 31, 'Commercial, Service Industry, Temperature Control and Air-Flow Control Machinery Manufacturing'),
(3336, 31, 'Engine, Turbine and Power Transmission Equipment Manufacturing'),
(3341, 31, 'Computer and Peripheral Equipment Manufacturing'),
(3342, 31, 'Communications, Audio and Video Equipment Manufacturing'),
(3344, 31, 'Semiconductor and Other Electronic Component Manufacturing'),
(3345, 31, 'Navigational, Measuring, Electromedical, and Control Instruments Manufacturing, Radio/Television Broadcasting and Wireless Communications Equipment Manufacturing, Communications Signal Testing and Evaluation Equipment'),
(3346, 31, 'Manufacturing and Reproducing Magnetic and Optical Media'),
(3350, 31, 'Electrical Equipment, Appliance and Component Manufacturing'),
(3361, 31, 'Motor Vehicle, Body, Trailer and Parts Manufacturing'),
(3364, 31, 'Aerospace Product and Parts Manufacturing'),
(3369, 31, 'Other Transportation Equipment Manufacturing (Including inflatable boats)'),
(3370, 31, 'Furniture and Related Product Manufacturing (Including Laboratory Furniture)'),
(3391, 31, 'Medical Equipment and Supplies Manufacturing'),
(3399, 31, 'Other Miscellaneous Manufacturing'),
(4230, 42, 'Merchant Wholesalers, Durable Goods'),
(4240, 42, 'Merchant Wholesalers, Nondurable Goods'),
(4250, 42, 'Wholesale Electronic Markets and Agents and Brokers'),
(4410, 44, 'Motor Vehicles and Parts Dealers'),
(4430, 44, 'Electronics and Appliance Stores'),
(4450, 44, 'Food and Beverage Stores'),
(4480, 44, 'Clothing and Clothing Accessories Stores'),
(4520, 44, 'General Merchandise Stores'),
(4540, 44, 'Nonstore Retailers'),
(4599, 44, 'Other Retail Trade Stores, including Gasoline Stations'),
(4810, 48, 'Air Transportation'),
(4820, 48, 'Rail Transportation'),
(4830, 48, 'Water Transportation'),
(4840, 48, 'Truck Transportation'),
(4850, 48, 'Transit and Ground Passenger Transportation'),
(4861, 48, 'Pipeline Transportation of Crude Oil, Refined Petroleum and Miscellaneous Products, except Natural Gas'),
(4862, 48, 'Pipeline Transportation of Natural Gas'),
(4870, 48, 'Scenic and Sightseeing Transportation'),
(4880, 48, 'Support Activities for Transportation'),
(4920, 48, 'Couriers and Messengers'),
(4930, 48, 'Warehousing and Storage'),
(5111, 51, 'Newspaper, Periodical, Book and Directory Publishers (except Internet)'),
(5112, 51, 'Software Publishers (except Internet)'),
(5151, 51, 'Radio and Television Broadcasting (except Internet)'),
(5152, 51, 'Cable and Other Subscription Programming (except Internet)'),
(5171, 51, 'Wired Telecommunications Carriers, Cable and Other Program Distribution, Broadband Internet Service Providers (e.g., cable, DSL)'),
(5172, 51, 'Wireless Telecommunications Carriers (except Satellite)'),
(5179, 51, 'Telecommunications Resellers, Satellite and Other Telecommunications(Including Internet Service Providers providing services via client supplied telecommunication connection)'),
(5182, 51, 'Data Processing, Hosting and Related Services'),
(5190, 51, 'Other Information Services'),
(5210, 52, 'Monetary Authorities-Central Bank'),
(5221, 52, 'Depository Credit Intermediation'),
(5222, 52, 'Nondepository Credit Intermediation'),
(5223, 52, 'Activities Related to Credit Intermediation'),
(5230, 52, 'Securities, Commodity Contracts and Other Financial Investments and Related Activities'),
(5241, 52, 'Insurance Carriers'),
(5242, 52, 'Agencies, Brokerages and Other Insurance Related Activities'),
(5251, 52, 'Funds, Trusts and Other Financial Vehicles (including Mortgage REITS)'),
(5310, 53, 'Real Estate (including Equity REITS)'),
(5321, 53, 'Automotive Equipment Rental and Leasing'),
(5322, 53, 'Consumer Goods and General Rental Centers'),
(5324, 53, 'Commercial and Industrial Machinery and Equipment Rental and Leasing'),
(5330, 53, 'Lessors of Nonfinancial Intangible Assets'),
(5411, 54, 'Legal Services'),
(5412, 54, 'Accounting, Tax Preparation, Bookkeeping and Payroll Services'),
(5413, 54, 'Architectural, Engineering and Related Services'),
(5414, 54, 'Specialized Design Services'),
(5415, 54, 'Computer Systems Design and Related Service'),
(5416, 54, 'Management, Scientific and Technical Consulting Services'),
(5417, 54, 'Scientific Research and Development Services'),
(5418, 54, 'Advertising and Related Services'),
(5419, 54, 'Other Professional, Scientific and Technical Services'),
(5510, 55, 'Management of Companies and Enterprises'),
(5614, 56, 'Business Support Services'),
(5615, 56, 'Travel Arrangement and Reservation Services'),
(5616, 56, 'Investigation, Security and Services to Buildings and Dwellings'),
(5619, 56, 'Office Administrative, Facilities, Employment and Other Support Services'),
(5621, 56, 'Waste Collection, Treatment and Disposal'),
(5629, 56, 'Remediation and Other Waste Management Services'),
(6110, 61, 'Educational Services'),
(6211, 62, 'Offices of Physicians'),
(6212, 62, 'Offices of Dentists and Other Health Practitioners'),
(6215, 62, 'Medical and Diagnostics Laboratories'),
(6216, 62, 'Home Health Care Services'),
(6219, 62, 'Outpatient Care Centers and Other Ambulatory Health Care Services'),
(6221, 62, 'General Medical and Surgical Hospitals'),
(6222, 62, 'Psychiatric, Substance Abuse and Specialty Hospitals'),
(6230, 62, 'Nursing and Residential Care Facilities'),
(6240, 62, 'Social Assistance (except Child Day Care Services)'),
(6244, 62, 'Child Day Care Services'),
(7110, 71, 'Performing Arts, Spectator Sports and Related Industries'),
(7120, 71, 'Museums, Historical Sites and Similar Institutions'),
(7130, 71, 'Amusement, Gambling and Recreation Industries'),
(7210, 72, 'Traveler Accomodation Services'),
(7220, 72, 'Food Services and Drinking Places'),
(8111, 81, 'Automotive Repair and Maintenance'),
(8119, 81, 'Other Repair and Maintenance'),
(8120, 81, 'Personal Care, Death Care, Laundry and Other Personal Services'),
(8131, 81, 'Religious, Grantmaking, Social Advocacy, Civic and Social Organizations'),
(8139, 81, 'Business, Professional, Labor, Political and Similar Organizations'),
(9900, 99, 'Central Administrative Office Activity Unallocated to Other Industry Categories');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `business_category`
--
ALTER TABLE `business_category`
ADD UNIQUE KEY `ID` (`ID`);
COMMIT;
Subscribe to:
Posts (Atom)