List:General Discussion« Previous MessageNext Message »
From:Tonu Samuel Date:October 4 1999 2:42pm
Subject:Re: insert in multiple tables
View as plain text  
Bart Zylowski wrote:
> 
> Hi,
> 
> I'm newbe with mysql and I want to know if it's
> possible to insert values in more than one table
> at once.( with an unique query)
> ex. :
> 
> insert into table.1 values ('1', '2', '3') and insert into table2 values
> ('4', '5', '6');

No, you can't.

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+
Thread
insert in multiple tablesBart Zylowski4 Oct
  • Re: insert in multiple tablesTonu Samuel4 Oct