Create Database myjpm;

use myjpm;


CREATE TABLE IF NOT EXISTS `personal` (
  `name` varchar(30) NOT NULL DEFAULT '',
  `address` varchar(45) DEFAULT NULL,
  `contact` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`),
  FULLTEXT KEY `name` (`name`,`address`,`contact`,`email`),
  FULLTEXT KEY `name_2` (`name`,`address`),
  FULLTEXT KEY `name_3` (`name`,`address`),
  FULLTEXT KEY `name_4` (`name`,`address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personal`
--

INSERT INTO `personal` (`name`, `address`, `contact`, `email`, `age`) VALUES
('Mike', 'no 1 jalan 1, petaling jaya', '03-77388457', 'mike@domain.com', 10),
('John', 'Kuala Lumpur', '4533', 'john@domain.com', 21),
('Berry', 'Petaling Jaya', '66332', 'berry@yahoo.com', 25),
('Jenny', 'Kuala Lumpur', '98765', 'jen@domain.com', 28),
('Krishnan', 'Rawang', '0126853582', 'krishna@vigshakri.com', 45),
('romo', 'Petaling Jaya', '12321', 'romo@mail.com', 5),
('FANZO', 'Petaling Jaya', '123', 'e@d.com', 10),
('GINGER', 'Petaling Jaya', '123', 'e@d.com', 10),
('jackie', 'Petaling Jaya', 'heav111', 'heav@sky.com', 12),
('donal', 'KL', '123', 'e@d.com', 11),
('aa', 'bb', 'cc', 'dd', 11),
('JName', 'PJ', 'J009', 'jname@mail.com', 2);