目前我有以下声明:
INSERT INTO furniture (model,type) VALUES (modelA,chair)
INSERT INTO furniture (model,type) select 'modelA','chair' where exists (select * from model where model.model = 'modelA');
您没有告诉我们调用引用的表是什么.我认为它的模型 – 你需要调整到真实的名字.