在网上看了好多例子,总也调试不好 求高手帮帮忙,最好给出调试好的代码。
CREATE TABLE `reply` (
`replyId` int(11) NOT NULL auto_increment,
`topicId` int(11) default NULL,
`userId` int(11) default NULL,
`replyTitle` varchar(200) default NULL,
`replyContent` varchar(250) default NULL,
`screenSign` int(11) default NULL,
`replyTime` varchar(20) default NULL,
`replyImage` varchar(200) default NULL,
PRIMARY KEY (`replyId`),
KEY `FK_Relationship_3` (`topicId`),
KEY `FK_Relationship_5` (`userId`),
CONSTRAINT `FK_Relationship_3` FOREIGN KEY (`topicId`) REFERENCES `topic` (`topicId`),
CONSTRAINT `FK_Relationship_5` FOREIGN KEY (`userId`) REFERENCES `users` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;文件名最好是加userId 和topicId,replyId加上发表时间的JSPMySQLTomcat图片存储
CREATE TABLE `reply` (
`replyId` int(11) NOT NULL auto_increment,
`topicId` int(11) default NULL,
`userId` int(11) default NULL,
`replyTitle` varchar(200) default NULL,
`replyContent` varchar(250) default NULL,
`screenSign` int(11) default NULL,
`replyTime` varchar(20) default NULL,
`replyImage` varchar(200) default NULL,
PRIMARY KEY (`replyId`),
KEY `FK_Relationship_3` (`topicId`),
KEY `FK_Relationship_5` (`userId`),
CONSTRAINT `FK_Relationship_3` FOREIGN KEY (`topicId`) REFERENCES `topic` (`topicId`),
CONSTRAINT `FK_Relationship_5` FOREIGN KEY (`userId`) REFERENCES `users` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;文件名最好是加userId 和topicId,replyId加上发表时间的JSPMySQLTomcat图片存储
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货