Student Table ( Sample )



Creating sample MySQL student table using SQL dump in Workbench

idnameclassmarkgender
1John DeoFour75female
2Max RuinThree85male
3ArnoldThree5male
4Krish StarFour60female
5John MikeFour60female
6Alex JohnFour55male
7My John RobFive78male
8AsruidFive85male
9Tes QrySix78male
10Big JohnFour55female
11RonaldSix89female
12ReckySix94female
13KtySeven88female
14BigySeven88female
15Tade RowFour88male
16GimmyFour88male
17TumyuSix54male
18HonnyFive75male
19TinnyNine18male
20JacklyNine65female
21Babby JohnFour69female
22ReggidSeven55female
23HerodEight79male
24Tiddy NowSeven78male
25Giff TowSeven88male
26CreleaSeven79male
27Big NoseThree81female
28Rojj BaseSeven86female
29Tess PlayedSeven55male
30Reppy RedSix79female
31Marry ToeeyFour88male
32Binn RottSeven90female
33Kenn ReinSix98female
34Gain ToeSeven69male
35Rows NoumpSix88female

SQL Dump of Student table

Table structure using auto incremented id field. More on Auto Incremented id Field..
CREATE TABLE IF NOT EXISTS `student` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `class` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `mark` int(3) NOT NULL DEFAULT '0',
  `gender` varchar(6) CHARACTER SET utf8 NOT NULL DEFAULT 'male',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Text file of SQL dump of Student table

SQL dump of student with AUTO_INCREMENT id field



SQL dump of student_sum , SQL SUM Multiple

SQL student table as Json string
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com

    Post your comments , suggestion , error , requirements etc here





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer