什么也不说,先上结构
CREATE TABLE `weibo_comment` (
`commentid` int(11) NOT NULL AUTO_INCREMENT ,
`weiboid` int(11) NOT NULL ,
`uid` int(11) NOT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`datetime` int(11) NOT NULL ,
`syncid` int(11) NOT NULL DEFAULT 0 ,
`synctype` tinyint(4) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`commentid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=37
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
INSERT INTO `qsj_weibo_comment` VALUES (1, 47, 100000, '34535', 1350355452, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (2, 47, 100000, '34535', 1350355456, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (3, 47, 100000, '34535', 1350355471, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (4, 47, 100000, '34535222', 1350355478, 0, 0);
CREATE TABLE `weibo` (
`weiboid` int(11) NOT NULL AUTO_INCREMENT ,
`uid` int(11) NOT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`type` enum('0','1','2','3','4') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`comment_num` int(11) NOT NULL DEFAULT 0 ,
`datetime` int(11) NOT NULL ,
PRIMARY KEY (`weiboid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=49
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
INSERT INTO `qsj_weibo` VALUES (1, 100001, '我很好哦', '0', '1', 0, 1349421231);
INSERT INTO `qsj_weibo` VALUES (2, 100005, '我刚才创建了杂志', '1', '1', 0, 1349421243);
INSERT INTO `qsj_weibo` VALUES (3, 100005, '我收藏了产品', '2', '1', 0, 1349421449);
现在我要想到得到如下结果。
怎么查才能从weibo_comment表中查到回复是属于某个微博发表人的。
CREATE TABLE `weibo_comment` (
`commentid` int(11) NOT NULL AUTO_INCREMENT ,
`weiboid` int(11) NOT NULL ,
`uid` int(11) NOT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`datetime` int(11) NOT NULL ,
`syncid` int(11) NOT NULL DEFAULT 0 ,
`synctype` tinyint(4) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`commentid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=37
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
INSERT INTO `qsj_weibo_comment` VALUES (1, 47, 100000, '34535', 1350355452, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (2, 47, 100000, '34535', 1350355456, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (3, 47, 100000, '34535', 1350355471, 0, 0);
INSERT INTO `qsj_weibo_comment` VALUES (4, 47, 100000, '34535222', 1350355478, 0, 0);
CREATE TABLE `weibo` (
`weiboid` int(11) NOT NULL AUTO_INCREMENT ,
`uid` int(11) NOT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`type` enum('0','1','2','3','4') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`comment_num` int(11) NOT NULL DEFAULT 0 ,
`datetime` int(11) NOT NULL ,
PRIMARY KEY (`weiboid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=49
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
INSERT INTO `qsj_weibo` VALUES (1, 100001, '我很好哦', '0', '1', 0, 1349421231);
INSERT INTO `qsj_weibo` VALUES (2, 100005, '我刚才创建了杂志', '1', '1', 0, 1349421243);
INSERT INTO `qsj_weibo` VALUES (3, 100005, '我收藏了产品', '2', '1', 0, 1349421449);
现在我要想到得到如下结果。
怎么查才能从weibo_comment表中查到回复是属于某个微博发表人的。
二个表都对不上?哪个是那个?
qsj_weibo此表在哪里?
提问题要把问题组织好。