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 |
+----------------------------------------------------------------+