晕~~~~~~
#
# Table structure for table 'ta'
#CREATE TABLE ta (
id tinyint(3) unsigned NOT NULL default '0',
class char(3) NOT NULL default '',
PRIMARY KEY (id),
KEY class (class)
) TYPE=MyISAM CHARSET=latin1;#
# Dumping data for table 'ta'
#INSERT INTO ta VALUES("1", "A");
INSERT INTO ta VALUES("2", "B");
INSERT INTO ta VALUES("3", "C");
INSERT INTO ta VALUES("4", "B");
INSERT INTO ta VALUES("5", "A");mysql> SELECT MAX(`id`),`class` FROM `tA` GROUP BY `class`;
+-----------+-------+
| MAX(`id`) | class |
+-----------+-------+
| 5 | A |
| 4 | B |
| 3 | C |
+-----------+-------+
#
# Table structure for table 'ta'
#CREATE TABLE ta (
id tinyint(3) unsigned NOT NULL default '0',
class char(3) NOT NULL default '',
PRIMARY KEY (id),
KEY class (class)
) TYPE=MyISAM CHARSET=latin1;#
# Dumping data for table 'ta'
#INSERT INTO ta VALUES("1", "A");
INSERT INTO ta VALUES("2", "B");
INSERT INTO ta VALUES("3", "C");
INSERT INTO ta VALUES("4", "B");
INSERT INTO ta VALUES("5", "A");mysql> SELECT MAX(`id`),`class` FROM `tA` GROUP BY `class`;
+-----------+-------+
| MAX(`id`) | class |
+-----------+-------+
| 5 | A |
| 4 | B |
| 3 | C |
+-----------+-------+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货