Hi, I have tried:
mysql> create table z(id int unsigned not null primary key, first_name varchar(20), last_name varchar(20)); Query OK, 0 rows affected (0.06 sec) mysql> insert into z values(1, 'John', 'Smith'), (2, 'George', 'Washington'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from z; +----+------------+------------+ | id | first_name | last_name | +----+------------+------------+ | 1 | John | Smith | | 2 | George | Washington | +----+------------+------------+ 2 rows in set (0.00 sec) mysql> replace into z values(1, 'Michael', 'Rifle'); Query OK, 2 rows affected (0.00 sec) mysql> select * from z; +----+------------+------------+ | id | first_name | last_name | +----+------------+------------+ | 1 | Michael | Rifle | | 2 | George | Washington | +----+------------+------------+ 2 rows in set (0.00 sec) mysql> Is there a bug that MySQL says "Query OK, 2 rows affected (0.00 sec)" although only a single row was modified (as it should)? I am using the version 5.0.15-nt. Thanks. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
