· 9 years ago · Apr 11, 2017, 06:42 AM
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
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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
29CREATE 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
51INSERT 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 */;