1. For the company called ‘Ernst Handel’, change the name of thecontact person to Hans Schmidt.

2. Increase each UnitPrice in the Products table by $1 (assumingthe unit price is in $’s).

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
`CustomerID` varchar(5) DEFAULT NULL,
`CompanyName` mediumtext,
`ContactName` mediumtext,
`ContactTitle` mediumtext,
`Address` mediumtext,
`City` mediumtext,
`Region` mediumtext,
`PostalCode` mediumtext,
`Country` mediumtext,
`Phone` mediumtext,
`Fax` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`ProductID` int(11) DEFAULT NULL,
`ProductName` mediumtext,
`SupplierID` int(11) DEFAULT NULL,
`CategoryID` int(11) DEFAULT NULL,
`QuantityPerUnit` mediumtext,
`UnitPrice` double DEFAULT NULL,
`UnitsInStock` smallint(6) DEFAULT NULL,
`UnitsOnOrder` smallint(6) DEFAULT NULL,
`ReorderLevel` smallint(6) DEFAULT NULL,
`Discontinued` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--

MySQL please provide with data