Guest User

Untitled

a guest
Apr 11th, 2017
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.69 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.1.14
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Apr 11, 2017 at 08:39 AM
  7. -- Server version: 5.6.17
  8. -- PHP Version: 5.5.12
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `data`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `student_form`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `student_form` (
  30. `s.no` int(11) NOT NULL AUTO_INCREMENT,
  31. `name` varchar(100) NOT NULL,
  32. `father_name` varchar(100) NOT NULL,
  33. `postal_address` varchar(100) NOT NULL,
  34. `personal_address` varchar(100) NOT NULL,
  35. `sex` varchar(100) NOT NULL,
  36. `city` varchar(100) NOT NULL,
  37. `course` varchar(100) NOT NULL,
  38. `district` varchar(100) NOT NULL,
  39. `state` varchar(100) NOT NULL,
  40. `pincode` varchar(100) NOT NULL,
  41. `email_id` varchar(100) NOT NULL,
  42. `dob` varchar(100) NOT NULL,
  43. `mobile_no` varchar(100) NOT NULL,
  44. PRIMARY KEY (`s.no`)
  45. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
  46.  
  47. --
  48. -- Dumping data for table `student_form`
  49. --
  50.  
  51. INSERT INTO `student_form` (`s.no`, `name`, `father_name`, `postal_address`, `personal_address`, `sex`, `city`, `course`, `district`, `state`, `pincode`, `email_id`, `dob`, `mobile_no`) VALUES
  52. (1, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'Mumbai', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  53. (2, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'Nalanda', 'Goa', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  54. (3, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'Mumbai', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  55. (4, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'Mumbai', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  56. (5, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'Mumbai', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  57. (6, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'Mumbai', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  58. (18, 'sunil kainth', 'bhupinder singh', 'kharar', 'ropar', 'male', 'Mumbai', 'B.Tech', 'UP', 'New Delhi', '140301', 'cheenakainth1@gmail.com', '16/04/1993', '8196803344'),
  59. (22, 'rahul sharma', 'anil kumar', 'baltana', 'zirakpur', 'male', 'New Delhi', 'B.Tech', 'Nalanda', 'New Delhi', '140301', 'rahulsharma@gmail.com', '16/04/1993', '9781163891'),
  60. (39, 'nadeem', 'nadeem', 'fkjkejfoi', 'oijfiowj', 'male', 'Mumbai', 'MCA', 'Nalanda', 'Mumbai', '2151', 'cfsrdw', '215', '545187'),
  61. (54, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  62. (55, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  63. (56, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  64. (57, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  65. (58, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  66. (59, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  67. (60, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  68. (61, '', '', '', '', '', '', '', '', '', '', '', '', ''),
  69. (62, '', '', '', '', '', '', '', '', '', '', '', '', '');
  70.  
  71. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  72. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  73. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Add Comment
Please, Sign In to add comment