--
-- Table structure for table `students`
--

CREATE TABLE IF NOT EXISTS `students` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(255) NOT NULL,
  `student_email` varchar(255) NOT NULL,
  `student_city` varchar(255) NOT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`student_id`, `student_name`, `student_email`, `student_city`) VALUES
(1, 'Jack Smith', 'jack123@gmail.com', 'new york'),
(2, 'John kartar', 'john@gmail.com', 'las vegas'),
(3, 'Cristiano Ronaldo', 'ronaldo123@gmail.com', 'Chicago'),
(4, 'David smith', 'david@gmail.com', 'Los Angeles');