Advertisement
Guest User

Untitled

a guest
May 21st, 2017
555
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement