sql嵌套插入查询 [英] sql nested insert into query
本文介绍了sql嵌套插入查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如何创建嵌套的sql insert查询？
我试过这个，但是不行！
How do I create a nested sql insert query ?
I've tried this, but is does't work!
$user = "mymail@gmail.com";
$item = "some value";
$query = "INSERT INTO (SELECT user_ref FROM users WHERE mail ='$user') (item) VALUES ('$item')";
推荐答案
user = mymail@gmail.com;
user = "mymail@gmail.com";
item = 某些值;
item = "some value";
query = INSERT INTO（SELECT user_ref FROM users WHERE mail ='
query = "INSERT INTO (SELECT user_ref FROM users WHERE mail ='
这篇关于sql嵌套插入查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
