tableA:
idA uid address price tableB:
idB uid name age
insert into tableB(idB,uid,name,age) values(0,xxx,'kala',34)现在已知的是tableA的idA,想通过idA得到tableA的uid,再把该uid放到上边查询中的xxx里这个联表插入操作怎么写呢?
idA uid address price tableB:
idB uid name age
insert into tableB(idB,uid,name,age) values(0,xxx,'kala',34)现在已知的是tableA的idA,想通过idA得到tableA的uid,再把该uid放到上边查询中的xxx里这个联表插入操作怎么写呢?
select 0,uid,'kala',34 from tableA where idA=123
where ida='123'