Are you trying to do an Insert On Duplicate Key? Do ou want to insert a new row if it doesn't already exist or update one if it does?
On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan <[email protected]> wrote: > Are you talking about Length/Values1 > > > > --- On Mon, 3/2/09, Gary Smith <[email protected]> wrote: > > From: Gary Smith <[email protected]> > Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY' > To: [email protected], [email protected] > Date: Monday, March 2, 2009, 1:58 PM > > Easy. Ensure that all in the primary key have unique values. > > With that said, it would be more useful to have a ddl and the query causing > the > problem. > > > ------Original Message------ > From: sam rumaizan > To: [email protected] > ReplyTo: [email protected] > Sent: Mar 2, 2009 12:56 PM > Subject: Error: Duplicate entry '0' for key 'PRIMARY' > > Error: Duplicate entry '0' for key 'PRIMARY' > > how can i fix it ? > > > > > > Sent via BlackBerry by AT&T > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
