新建两张表table test
和table foreignTable
sql语句:
select t.*, t.rowid from TEST t
insert into test values('','1','11')
insert into test values('ning','0','22')
insert into test values('chen','1','33')--要创建该字段,首先要保证外键‘chen’这个字段在foreignTable这张表中存在,即为该表的主键
delete from te