hi, Thanks for the response. I thought update is for existing records and insert is to add new records?
My Scenario is if two users open an existing record with data already in the fields. They then add some information to the end of a field with data. Now when they click update the last user/browser gets written to the db, where the first users data is over written. I thought innodb would help this.. user a: user b: pulls up record 5 pulls up record 5 adds/appends line to field b adds/appends line to field b clicks update first clicks update second user b's line is added/appended to record 5, user a's line is overwritten not even seen. Ron -----Original Message----- From: Batara Kesuma [mailto:[EMAIL PROTECTED] Sent: Saturday, January 17, 2004 4:20 AM To: [EMAIL PROTECTED] Subject: Re: Do I need Innodb? On Fri, 16 Jan 2004 13:43:55 -0800 "Ron McKeever" <[EMAIL PROTECTED]> wrote: > Scenario 1: > I have noticed that if two users open a record to edit it > in two different browsers > and they edit the same field and then click update, > the last user/browser gets written to the db, > where the first users data is over written. > > I would hope it would write user ones info then write user twos info, > without over writing user ones updates.... > > Will INNODB table type fix Scenario 1? No. You should use INSERT instead of UPDATE if you don't want the data to be overwritten. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
