Student Table ( Sample )

idnameclassmarksex
1John DeoFour75female
2Max RuinThree85male
3ArnoldThree5male
4Krish StarFour60female
5John MikeFour60female
6Alex JohnFour55male
7My John RobFifth78male
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',
  `sex` 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

Visitors Rating
Your Rating




Post your comments , suggestion , error , requirements etc here .








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