MySQL 5.5 Community Server MySQL 5.6 Community Server Percona Configuration Wizard XtraBackup 搭建主从复制 Great Sites on MySQL Percona MySQL Performance Blog Severalnines 推荐管理工具 Sequel Pro phpMyAdmin 推荐书目 MySQL Cookbook
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html 
这是一个创建于 4916 天前的主题，其中的信息可能已经有所发展或是发生改变。
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL,
`password` varchar(35) NOT NULL,
`groupid` int(11) NOT NULL,
`groupname` varchar(100) NOT NULL,
`phone` varchar(35),
`introduction` varchar(255),
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
CONSTRAINT FOREIGN KEY ('groupid', 'groupname')
REFERENCES group ('id', 'groupname')
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''groupid', 'groupname')
REFERENCES group ('id', 'groupname')
ON DELETE RESTRICT
`id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL,
`password` varchar(35) NOT NULL,
`groupid` int(11) NOT NULL,
`groupname` varchar(100) NOT NULL,
`phone` varchar(35),
`introduction` varchar(255),
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
CONSTRAINT FOREIGN KEY ('groupid', 'groupname')
REFERENCES group ('id', 'groupname')
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''groupid', 'groupname')
REFERENCES group ('id', 'groupname')
ON DELETE RESTRICT
 | 1 fanzeyi 2012-07-07 19:34:57 +08:00  1 CONSTRAINT FOREIGN KEY (`groupid`, `groupname`) REFERENCES `group` (`id`, `groupname`) 试试 |
 | 2 smoker OP 沉的好快。。。 那我说明下。。 问题出在 CONSTRAINT FOREIGN KEY ('groupid', 'groupname') REFERENCES group ('id', 'groupname') ON DELETE RESTRICT ON UPDATE CASCADE 这段上，其中group是需要链接的表， id是PRIMARY KEY, groupname是UNIQUE KEY 然后……然后就出错了。。。 |
| 3 smoker OP 居然成了。。。。谢谢！！！ 奇怪明明刚才自己加''了也不行。。。总之复制你这个好了。。 |
Select Language