PNDvRmD8

1
2Create Database myjpm;
3
4use myjpm;
5
6
7CREATE TABLE IF NOT EXISTS `personal` (
8  `name` varchar(30) NOT NULL DEFAULT '',
9  `address` varchar(45) DEFAULT NULL,
10  `contact` varchar(45) DEFAULT NULL,
11  `email` varchar(45) DEFAULT NULL,
12  `age` int(11) DEFAULT NULL,
13  PRIMARY KEY (`name`),
14  FULLTEXT KEY `name` (`name`,`address`,`contact`,`email`),
15  FULLTEXT KEY `name_2` (`name`,`address`),
16  FULLTEXT KEY `name_3` (`name`,`address`),
17  FULLTEXT KEY `name_4` (`name`,`address`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1;
19
20--
21-- Dumping data for table `personal`
22--
23
24INSERT INTO `personal` (`name`, `address`, `contact`, `email`, `age`) VALUES
25('Mike', 'no 1 jalan 1, petaling jaya', '03-77388457', 'mike@domain.com', 10),
26('John', 'Kuala Lumpur', '4533', 'john@domain.com', 21),
27('Berry', 'Petaling Jaya', '66332', 'berry@yahoo.com', 25),
28('Jenny', 'Kuala Lumpur', '98765', 'jen@domain.com', 28),
29('Krishnan', 'Rawang', '0126853582', 'krishna@vigshakri.com', 45),
30('romo', 'Petaling Jaya', '12321', 'romo@mail.com', 5),
31('FANZO', 'Petaling Jaya', '123', 'e@d.com', 10),
32('GINGER', 'Petaling Jaya', '123', 'e@d.com', 10),
33('jackie', 'Petaling Jaya', 'heav111', 'heav@sky.com', 12),
34('donal', 'KL', '123', 'e@d.com', 11),
35('aa', 'bb', 'cc', 'dd', 11),
36('JName', 'PJ', 'J009', 'jname@mail.com', 2);