Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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),
- ('JName', 'PJ', 'J009', 'jname@mail.com', 2),
- ('admin', 'kl', '15', 'admin', 15),
- ('aa', 'KL', '777744333', 'mail@mail.com', 2),
- ('T1', 'ADDRESS 1', '111111', 'MAIL', 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement