用mysql设计两张表aaa和bbbbbb的user参考aaa的user插入bbb一行时如果aaa中的值为1就能成功插入bbb如果aaa中的值为0就插入失败

CREATE TABLE aaa ( id INT PRIMARY KEY AUTO_INCREMENT, user VARCHAR(50), value INT );

CREATE TABLE bbb ( id INT PRIMARY KEY AUTO_INCREMENT, user VARCHAR(50), value INT, FOREIGN KEY (user) REFERENCES aaa(user) );

INSERT INTO aaa (user, value) VALUES ('user1', 1); INSERT INTO aaa (user, value) VALUES ('user2', 0);

INSERT INTO bbb (user, value) SELECT user, 1 FROM aaa WHERE user='user1' AND value=1; --成功插入一行

INSERT INTO bbb (user, value) SELECT user, 1 FROM aaa WHERE user='user2' AND value=1; --插入失败，因为aaa中的值为0