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]