附生成的sql數(shù)據(jù)代碼，復(fù)制到命令行運行即可。

DROP?TABLE?`user`;

CREATE?TABLE?`user`?(
??`id`?mediumint(8)?unsigned?NOT?NULL?auto_increment,
??`username`?varchar(255)?default?NULL,
??`score`?mediumint?default?NULL,
??`class`?mediumint?default?NULL,
??`grade`?mediumint?default?NULL,
??PRIMARY?KEY?(`id`)
)?AUTO_INCREMENT=1;

INSERT?INTO?`user`?(`username`,`score`,`class`,`grade`)?VALUES?("Ralph",84,3,3),("Gage",46,2,3),("Vivien",55,3,1),("Vladimir",55,2,2),("Cade",85,1,2),("Chelsea",31,1,3),("Ayanna",60,1,2),("Salvador",99,2,1),("Christopher",75,2,2),("Keiko",87,1,1),("Quinlan",76,1,1),("Berk",61,1,2),("Zephr",48,3,3),("Grace",96,2,2),("Nasim",69,2,2),("Reagan",35,1,3),("Vladimir",59,1,3),("Piper",42,2,3),("Keelie",85,1,3),("Alice",95,2,3),("Gregory",31,2,3),("Amy",32,3,3),("Inga",67,1,3),("Jessamine",50,1,3),("Julie",43,2,2),("Armand",64,2,1),("Timothy",67,3,1),("Rhona",85,2,2),("Charissa",56,3,3),("Coby",76,3,3),("Blythe",67,1,3),("Kelsie",89,2,1),("Lawrence",47,3,3),("Kimberley",76,1,3),("MacKensie",84,2,2),("Stone",32,3,2),("Kennan",99,1,3),("Carson",77,3,1),("Virginia",39,2,3),("Wesley",99,3,3),("Shaine",57,2,3),("Ayanna",75,1,3),("Justine",82,1,1),("Carlos",64,2,1),("Cooper",39,3,1),("Colette",71,1,2),("Xander",98,2,2),("Shea",90,1,1),("Dacey",30,3,1),("Rose",83,3,2);
INSERT?INTO?`user`?(`username`,`score`,`class`,`grade`)?VALUES?("Candice",91,2,1),("Cynthia",58,3,2),("Darryl",38,3,2),("Hedwig",46,1,1),("Ila",34,1,1),("Megan",38,2,1),("Charity",48,2,3),("Daryl",55,2,1),("Kaden",90,2,2),("Chester",62,1,1),("Kevyn",63,3,3),("Alvin",91,2,2),("Darius",99,3,3),("Keane",79,1,2),("Anne",38,2,3),("Ulysses",50,1,3),("Louis",58,3,2),("Idola",81,2,3),("Harrison",55,1,2),("Rashad",86,2,2),("Orli",55,1,3),("Clare",38,1,3),("Winter",30,1,3),("Tanisha",59,2,3),("Conan",71,3,3),("Kyle",92,2,3),("Zoe",100,3,2),("Jakeem",81,2,2),("Tucker",51,1,1),("Nash",68,3,3),("Hadley",58,1,3),("Destiny",55,2,3),("Ursula",78,2,3),("Echo",47,2,1),("Fulton",67,1,1),("Jane",90,3,1),("Charles",30,1,3),("Jacob",82,3,3),("Tatum",90,3,3),("Ginger",84,2,3),("Harriet",91,2,1),("Jeremy",86,1,3),("Lilah",69,3,2),("Phelan",33,3,1),("Gareth",70,1,1),("Wendy",33,1,1),("Stephen",41,3,2),("Willow",54,1,3),("Shafira",67,3,1),("Lyle",35,1,1);