Basic
Reputation: 1866
2 mysql entries into different tables in one query?
I know how to enter information into one table, but how would I enter or take information from 2 different tables at the same time. I have researched and it has something to do with JOIN, but I have tried to no avail!
Upvotes: 0
Views: 107
Answers (1)
zerkms
Reputation: 254916
It is not possible to insert into 2 tables in one query.
(Technically - you can create a trigger in table A, that inserts something to table B, but in this case you're not able to control what data to insert from the INSERT)
Upvotes: 2
Related Questions
- Two Tables - One Query for PHP output
- How do I use two mysql tables in one statement
- 2 MySQL SELECT Statements in one PHP query
- select from two different tables in single query using mysql
- Getting 2 mysql queries into one?
- MySQL - querying same table twice
- Two tables into 1 SQL Query
- MySQL Query 2 Tables in 1
- Query two SQL entries?
- Run two queries on the same table at once?