· 7 years ago · Sep 19, 2018, 10:50 AM
1--
2-- Table structure for table `students`
3--
4
5CREATE TABLE IF NOT EXISTS `students` (
6 `student_id` int(11) NOT NULL AUTO_INCREMENT,
7 `student_name` varchar(255) NOT NULL,
8 `student_email` varchar(255) NOT NULL,
9 `student_city` varchar(255) NOT NULL,
10 PRIMARY KEY (`student_id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
12
13--
14-- Dumping data for table `students`
15--
16
17INSERT INTO `students` (`student_id`, `student_name`, `student_email`, `student_city`) VALUES
18(1, 'Jack Smith', 'jack123@gmail.com', 'new york'),
19(2, 'John kartar', 'john@gmail.com', 'las vegas'),
20(3, 'Cristiano Ronaldo', 'ronaldo123@gmail.com', 'Chicago'),
21(4, 'David smith', 'david@gmail.com', 'Los Angeles');