CREATE TABLE `score` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`score` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (1, '一班', '小赵', 85);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (2, '一班', '小钱', 70);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (3, '二班', '小孙', 60);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (4, '三班', '小李', 60);
INSERT INTO `score` (&
mysql分组之后取每组前几条数据
最新推荐文章于 2024-05-08 09:29:16 发布
CREATE TABLE `score` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `score` int(11) NOT NULL DEFAULT '0', PRIMAR.
摘要由CSDN通过智能技术生成