SHARE
TWEET

Untitled

a guest May 21st, 2017 531 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. CREATE 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.  
  19. INSERT 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);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top