先试试这样能不能取到记录 select tb.* from (select * from a,b) as tb where instr(tb.content,tb.name)>0 如果可以的话 insert into c select tb.* from (select * from a,b) as tb where instr(tb.content,tb.name)>0
mysql数据库中两个表的比较对比和提取数据
先试试这样能不能取到记录
select tb.* from (select * from a,b) as tb where instr(tb.content,tb.name)>0
如果可以的话
insert into c select tb.* from (select * from a,b) as tb where instr(tb.content,tb.name)>02011-11-12