SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE DATABASE `cars`;
USE `cars`;
CREATE TABLE IF NOT EXISTS `tb_cars` (
`ID` int(11) NOT NULL,
`VENDOR` varchar(20) CHARACTER SET utf8 NOT NULL,
`MODEL` varchar(20) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `tb_cars` (`ID`, `VENDOR`, `MODEL`) VALUES
(1, 'AUDI', 'A6'),
(2, 'AUDI', 'A8'),
(3, 'AUDI', 'Q9'),
(4, 'BMW', 'X3'),
(5, 'BMW', 'X5'),
(6, 'BMW', 'Z3'),
(7, 'BMW', 'Z5'),
(8, 'CHEVROLET', 'AVEO'),
(9, 'CHEVROLET', 'LACETTI'),
(10, 'CHEVROLET', 'CAPTIVA'),
(11, 'SUZUKI', 'SWIFT'),
(12, 'SUZUKI', 'SX4'),
(13, 'SUZUKI', 'GRAND VITARA'),
(14, 'TOYOTA', 'AVENSIS'),
(15, 'TOYOTA', 'COROLLA'),
(16, 'TOYOTA', 'CAMRY'),
(17, 'HYUNDAI', 'ACCENT'),
(18, 'HYUNDAI', 'SONATA'),
(19, 'HONDA', 'CIVIC'),
(20, 'HONDA', 'ACCORD'),
(21, 'FORD', 'FIESTA'),
(22, 'FORD ', 'FOCUS'),
(23, 'FORD', 'FUSION'),
(24, 'FORD ', 'TRANSIT'),
(25, 'MAZDA', '3'),
(26, 'MAZDA', '6'),
(27, 'MAZDA', 'CX7'),
(28, 'MITSUBISHI', 'LANCER'),
(29, 'MITSUBISHI', 'PAJERO'),
(30, 'MITSUBISHI', 'L 200');
|
Download
