Ac6GZhhR

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