请教一条mysql复合查询语句

Jatic Jatic 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
表 user 和 item 表结构及数据如下:
------------------------------------------
CREATE TABLE `user` (
`userid` smallint(6) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

INSERT INTO `user` VALUES (1, 'user1');
INSERT INTO `user` VALUES (2, 'user2');
INSERT INTO `user` VALUES (3, 'user3');
INSERT INTO `user` VALUES (4, 'user4');
INSERT INTO `user` VALUES (5, 'user5');

CREATE TABLE `item` (
`itemid` int(11) unsigned NOT NULL auto_increment,
`userid` smallint(6) unsigned NOT NULL default '0',
`content` varchar(100) NOT NULL default '',
`addtime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

INSERT INTO `item` VALUES (1, 1, 'content1', '2009-08-12 10:00:00');
INSERT INTO `item` VALUES (2, 1, 'content2', '2009-08-12 12:00:00');
INSERT INTO `item` VALUES (3, 2, 'content3', '2009-08-12 10:01:00');
INSERT INTO `item` VALUES (4, 2, 'content4', '2009-08-12 10:10:00');
INSERT INTO `item` VALUES (5, 2, 'content5', '2009-08-12 10:30:10');
INSERT INTO `item` VALUES (6, 4, 'content4', '2009-08-29 17:36:56');
INSERT INTO `item` VALUES (7, 5, 'content122', '2009-08-29 17:37:05');
INSERT INTO `item` VALUES (8, 5, 'content12', '2009-08-29 17:37:12');
INSERT INTO `item` VALUES (9, 5, 'content32', '2009-08-29 17:37:22');
INSERT INTO `item` VALUES (10, 5, 'content33', '2009-08-29 17:37:29');
INSERT INTO `item` VALUES (11, 5, 'content31', '2009-08-29 17:37:35');
INSERT INTO `item` VALUES (12, 3, 'content22', '2009-08-29 17:37:42');
INSERT INTO `item` VALUES (13, 3, 'content21', '2009-08-29 17:37:46');
INSERT INTO `item` VALUES (14, 3, 'content23', '2009-08-29 17:37:50');
INSERT INTO `item` VALUES (15, 3, 'content25', '2009-08-29 17:37:54');
INSERT INTO `item` VALUES (16, 3, 'content26', '2009-08-29 17:37:57');
INSERT INTO `item` VALUES (17, 4, 'content46', '2009-08-29 17:38:03');
INSERT INTO `item` VALUES (18, 4, 'content41', '2009-08-29 17:38:07');
INSERT INTO `item` VALUES (19, 4, 'content45', '2009-08-29 17:38:10');
INSERT INTO `item` VALUES (20, 4, 'content43', '2009-08-29 17:38:14');
INSERT INTO `item` VALUES (21, 4, 'content48', '2009-08-29 17:38:17');
INSERT INTO `item` VALUES (22, 4, 'content49', '2009-08-29 17:38:21');
INSERT INTO `item` VALUES (23, 4, 'content40', '2009-08-29 17:38:28');
INSERT INTO `item` VALUES (24, 2, 'content21', '2009-08-29 17:38:42');
INSERT INTO `item` VALUES (25, 2, 'content28', '2009-08-29 17:38:46');
INSERT INTO `item` VALUES (26, 2, 'content88', '2009-08-29 17:38:51');
INSERT INTO `item` VALUES (27, 1, 'content9', '2009-08-29 17:39:08');
INSERT INTO `item` VALUES (28, 1, 'content7', '2009-08-29 17:39:12');
INSERT INTO `item` VALUES (29, 1, 'content8', '2009-08-29 17:39:17');
INSERT INTO `item` VALUES (30, 1, 'content5', '2009-08-29 17:39:21');
INSERT INTO `item` VALUES (31, 3, 'content65', '2009-08-29 17:39:27');
INSERT INTO `item` VALUES (32, 4, 'content652', '2009-08-29 17:39:34');
INSERT INTO `item` VALUES (33, 4, 'content622', '2009-08-29 17:39:39');
INSERT INTO `item` VALUES (34, 5, 'content122', '2009-08-29 17:39:46');


现需要一条复合语名同时查询出所有资料,每一个用户名,只取出一条对应 item 里的内容

php 和 mysql 本是一家,这里牛人多,人气也高,所以想着发来这里
...全文
评论 5
收藏 已收藏
分享
返回顶部
Jatic
基础编程 21,889 成员 140,329 内容