From: Robert D. Lang CEO Date: March 23 1999 8:28pm Subject: Duplicate Keys. List-Archive: http://lists.mysql.com/mysql/847 Message-Id: <36F7F97A.81442483@rdlcom.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Dear Mysql Users:  I have two primary keys in a mysql table called, " user." They are for host and user fields. I am having a conflict with regards to updating due to this. I need to remove one of the primary keys so I do not have a conflict when writing to the database mysql. The error message is: mysql::st execute failed: Can't write, duplicate key in table 'user. I am new to mysql, so I am asking what is the command line needed to remove a primary key from a field? -- Sincerely, Robert D. Lang CEO RDL Communications Inc. Speak To Us: rdlcom@stripped   See Us: www.rdlcom.com