测试数据SQL文件
附生成的sql数据代码,复制到命令行运行即可。
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);