表A
id name
1 张三
2 李四
$a=‘张三,李四’
请问怎么通过$a将张三和李四的id同时写入到表B的a_id
即：
表B
id a_id
1 1,2
假定 表B 的 id 为自增字段
insert into 表B (a_id) select group_concat(id) from A表
不是这样，我是说要通过变量$a
如果$a='张三';
那么a_id的值就写入1
insert into 表B (a_id) select group_concat(id) from A表 where find_in_set(name, '$a')
那如果是修改update怎么写？？
update 表B set a_id=(select group_concat(id) from 表a where find_in_set(name, '$a'))
Windows driver wizard function
How to convert pdg files to pdf
How to resize pictures in ps
python configure environment variables
What are the software for learning python?
Recommended order for learning c++ and c language
What is javascript mainly used for?
The difference between large function and max
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
