可以通过一个插入查询php在mysql中的两个不同表中插入数据吗?
可能重复:
保存我的cookie数据到MySQL数据库?
我是编程新手，请与我合作.我有以这种形式保存在 cookie 中的数据.1:3456,2:12346,3:345678,4:1,5:3,6:3333,7:234,8:456789,9:3,10:2,11:34567,12:456,13:,13:!!145!!,14:1,Fname:Muhammad,Lname:Riazz,title:Developer,org:Magiclamp,email:riaz_qadeer90@yahoo.com
I am new in programming please co-operate with me. I have data in the form of this saved in cookies. 1:3456,2:12346,3:345678,4:1,5:3,6:3333,7:234,8:456789,9:3,10:2,11:34567,12:456,13:,13:!!145!!,14:1,Fname:Muhammad,Lname:Riazz,title:Developer,org:Magiclamp,email:riaz_qadeer90@yahoo.com
我想将这些数据保存在一个表中1:3456,2:12346,3:345678,4:1,5:3,6:3333,7:234,8:456789,9:3,10:2,11:34567,12:456,13:,13:!!145!!,14:1,
I want to save this data in one table 1:3456,2:12346,3:345678,4:1,5:3,6:3333,7:234,8:456789,9:3,10:2,11:34567,12:456,13:,13:!!145!!,14:1,
并希望将此保存到另一个表 Fname:Muhammad,Lname:Riazz,title:Developer,org:Magiclamp,email:riaz_qadeer90@yahoo.com
and want to save this an other table Fname:Muhammad,Lname:Riazz,title:Developer,org:Magiclamp,email:riaz_qadeer90@yahoo.com
有可能吗?
推荐答案
为什么需要用 1 个查询插入这个?单行 INSERT 查询对数据库来说并没有那么累，所以你最好只插入两次.
Why do you need to insert this with 1 query? Sole row INSERT queries aren't that exhausting for the database, so you might aswell just insert twice.
基本上 MySQL 不允许这样做.
Basicly MySQL doesn't allow this.
sql - 在一个查询中插入多个表
相关文章