可以通过一个插入查询php在mysql中的两个不同表中插入数据吗? [英] It is possible to insert data in two different table in mysql by one insert query php?

问题描述

可能重复:
保存我的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:[e-mail]

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:[e-mail]

我想将这些数据保存在一个表中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:[e-mail]

and want to save this an other table Fname:Muhammad,Lname:Riazz,title:Developer,org:Magiclamp,email:[e-mail]

有可能吗?

推荐答案

为什么需要用 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 - 在一个查询中插入多个表

这篇关于可以通过一个插入查询php在mysql中的两个不同表中插入数据吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！