Oganes, It sounds like what you want is row-level-locking. This is a feature of InnoDB tables. It allows users to write to a table while other users are reading from the same table. Of course, they cannot read and write the same rows simultaniously. Have you tried to do this and had some problem? If so you need to be much more specific about the problem you're encountering.
So, to answer your question: You can already do this. Eric Mayers Software Engineer I Captus Networks > -----Original Message----- > From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 2:34 PM > To: '[EMAIL PROTECTED]' > Subject: RE: InnoDB question > > > Hello everyone, > > I have this database, I'm using InnoDB type tables. I wanted > to know the > following: > > How can I manipulate the tables, so that db supports multiple > users trying > to access the same table for writing or reading purposes at > the same time. > > Thanks, > > Oganes Demirchyan > Motorola Life Science > 757 S.Raymond > Pasadena, CA 91105 > Tel: 626-584-5900 > email: [EMAIL PROTECTED] > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 2:26 PM > To: Demirchyan Oganes-AOD098 > Subject: Re: InnoDB question > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire > text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has > something to do > with MySQL. Just typing the word MySQL once will be > sufficient, for example. > > You have written the following: > > Hello everyone, > > I have this database, I'm using InnoDB type tables. I wanted > to know the > following: > > How can I manipulate the tables, so that db supports multiple > users trying > to access the same table for writing or reading purposes at > the same time. > > Thanks, > > Oganes Demirchyan > Motorola Life Science > 757 S.Raymond > Pasadena, CA 91105 > Tel: 626-584-5900 > email: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
