如题
与单键一样的
create table a1 (
b int(10),
c varchar(10),
d varchar(10),
FOREIGN KEY(B,C)
REFERENCES A(B,C)
)
CREATE TABLE `a` (
`b` int(10) NOT NULL DEFAULT '0',
`c` varchar(10) NOT NULL DEFAULT '',
`d` varchar(10) DEFAULT NULL,
PRIMARY KEY (`b`,`c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `a1` (
`b` int(10) DEFAULT NULL,
`c` varchar(10) DEFAULT NULL,
`d` varchar(10) DEFAULT NULL,
KEY `b` (`b`,`c`),
CONSTRAINT `a1_ibfk_1` FOREIGN KEY (`b`, `c`) REFERENCES `a` (`b`, `c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SQL code:
create table t1 (k1 int,k2 int, primary key (k1,k2));
create table t2 (
id int primary key,
k1 int,
k2 int,
foreign key (k1,k2) references t1(k1,k2)
);
insert into t1 values (1,1);
insert into t2 values (1,1,3);
insert into t2 values (1,1,1);
mysql> create table t1 (k1 int,k2 int, primary key (k1,k2));
Query OK, 0 rows affected (0.13 sec)
mysql> create table t2 (
-> id int primary key,
-> k1 int,
我以前安装了一次，后来卸载了，现在再安装的时候，提示错误：Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
可是我找 ......
在安装Java编译器的Eclipse的时候，对环境变量进行了配置，在安装MySQl的时候也要对环境变量进行配置；那么后面的配置会影响前面的Eclipse的配置吗？
请大家多指教~！谢谢！
不会把，我这都装了的 我系统里 还装了 ......
