On Tuesday 18 March 2003 17:20, Chris Wilson wrote:
> Using mysql 2.23.54a as both master & slave:
>
> ** On master:
>
> mysql> CREATE DATABASE repl_test;
> Query OK, 1 row affected (0.03 sec)
>
> mysql> USE repl_test;
> Database changed
> mysql> CREATE TABLE test (
> -> a INT UNSIGNED AUTO_INC
Hi all!
Using mysql 2.23.54a as both master & slave:
** On master:
mysql> CREATE DATABASE repl_test;
Query OK, 1 row affected (0.03 sec)
mysql> USE repl_test;
Database changed
mysql> CREATE TABLE test (
-> a INT UNSIGNED AUTO_INCREMENT NOT NULL ,
-> b INT UNSIGNED NOT NULL,
-> PRIM
Hi Guys,
http://www.mysql.com/doc/R/e/Replication_Features.html
... states that last_insert_id() will be replicated "correctly". However I
don't think this is always the case, for instance:
INSERT INTO TABLE tab1 (field1) values ("Test");
INSERT INTO TABLE tab2 (somefield) values (last_insert_
