感谢大神 回帖,, 这些表 主键 都是id, f: 主键 是id ----- u 表 主键也是id ----- t 表 主键 也是id -----其他 都是 字段
列出三个表的 create table 语句。
帖子表: CREATE TABLE `photo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` text NOT NULL, `description` text NOT NULL, `looked_num` int(10) unsigned NOT NULL DEFAULT '0', `author_id` int(10) unsigned NOT NULL, `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `type` int(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;图片文件表: DROP TABLE IF EXISTS `file`; CREATE TABLE `file` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `url` text NOT NULL, `photo_id` int(10) unsigned NOT NULL, `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;用户表: CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nickname` varchar(45) CHARACTER SET utf8 NOT NULL, `pwd` varchar(45) CHARACTER SET utf8 NOT NULL, `sign` text CHARACTER SET utf8, `phone` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `imgurl` text CHARACTER SET utf8, `sex` int(10) unsigned NOT NULL DEFAULT '1', `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) )
或者如果不方便贴,则检查这些t.file_id = f.tiezi_id u.id = t.user_id 哪一个不是主键,显然其中有某个是存在重复的。
这些表 主键 都是id, f: 主键 是id ----- u 表 主键也是id ----- t 表 主键 也是id -----其他 都是 字段
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`description` text NOT NULL,
`looked_num` int(10) unsigned NOT NULL DEFAULT '0',
`author_id` int(10) unsigned NOT NULL,
`createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`type` int(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;图片文件表:
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`photo_id` int(10) unsigned NOT NULL,
`createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;用户表:
CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nickname` varchar(45) CHARACTER SET utf8 NOT NULL,
`pwd` varchar(45) CHARACTER SET utf8 NOT NULL,
`sign` text CHARACTER SET utf8,
`phone` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
`imgurl` text CHARACTER SET utf8,
`sex` int(10) unsigned NOT NULL DEFAULT '1',
`createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
t.file_id = f.tiezi_id t.user_id
还是要谢谢 大神 的解答。。 回家自己搞去