我有两个表,主键和外键关系。下面是表结构。
Master Table
------------
create table phrase(id varchar(50) constraint phrase_pk primary key,name varchar(50))
Child Table
-----------
create table phrase_child(phrase_id varchar(50) constraint pharse_child_pharse foreign key references phrase(id))
Insert into phrase values('1','A');
Insert into phrase values('2','B')
Insert into phrase values('3','C')
insert into phrase_child values('1,2,3')
当我试图在子表中插入上述记录时,它将显示以下错误消息。
INSERT语句与外键约束“pharse_child_pharse”冲突。
Is it possible to insert like that in some other way using constraint?