Hello. There were several bugs in older versions of MySQL related to 'duplicate entry' errors. Do you use latest release? In documentation it is said that AUTO_INCREMENT works correctly with replication. Please also take a look in the documentation at these links: http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html http://dev.mysql.com/doc/mysql/en/InnoDB_auto-increment_column.html http://dev.mysql.com/doc/mysql/en/Replication_Problems.html
>Can anybody tell me how AUTO_INCREMENT works in MySQL especially when we are >using DB >Replications. >At times I get duplicate key error though taken care that the insertions and >updations are >done in the master db. "Mitul Bhammar" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
