可以的mysql> create table test.userinfo
-> (
-> id int(10) unsigned primary key auto_increment
-> )
-> ;
Query OK, 0 rows affected (0.00 sec)mysql> create table test2.homeImg
-> (
-> userId int(10) unsigned,
-> KEY userId (userId),
-> CONSTRAINT homeimg_userinfofk_1 FOREIGN KEY (userId) REFERENCES test.userinfo(id)
-> );
Query OK, 0 rows affected (0.00 sec)
-> (
-> id int(10) unsigned primary key auto_increment
-> )
-> ;
Query OK, 0 rows affected (0.00 sec)mysql> create table test2.homeImg
-> (
-> userId int(10) unsigned,
-> KEY userId (userId),
-> CONSTRAINT homeimg_userinfofk_1 FOREIGN KEY (userId) REFERENCES test.userinfo(id)
-> );
Query OK, 0 rows affected (0.00 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货