InnoDB Record Lock Command

Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables. Any urls out there? Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: InnoDB Record Lock Command

something along the lines of: mysql select * from table where column = value lock in share mode On Sep 5, 2005, at 4:01 PM, Rich wrote: Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables.

RE: Record Lock?

PROTECTED] Subject: Re: Record Lock? On Sun, Dec 08, 2002 at 12:06:53PM -0800, Richard Reina wrote: How do I switch from MYISAM to InnoDB? Are there any negative implication in swithing? ALTER table TYPE=InnoDB; It will take twice as much disk space or thereabouts and not support full text

Re: Record Lock?

On Sun, Dec 08, 2002 at 12:06:53PM -0800, Richard Reina wrote: How do I switch from MYISAM to InnoDB? Are there any negative implication in swithing? ALTER table TYPE=InnoDB; It will take twice as much disk space or thereabouts and not support full text queries. SQL -- Michael T.

Re: Record Lock?

Hi. On Sun 2002-12-08 at 14:50:35 +0200, [EMAIL PROTECTED] wrote: [...] SELECT * FROM your_table WHERE some-condition-for-the-row-in-question FOR UPDATE [...] I would like to clarify that InnoDB holds locks till the current transaction COMMIT or ROLLBACK. Thus, in the

Re: Record Lock?

Benjamin, - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 9:58 AM Subject: Re: Record Lock? Hi. On Sun 2002-12-08 at 14:50:35 +0200, [EMAIL PROTECTED] wrote: [...] SELECT

Re: Record Lock?

Hi! - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, December 08, 2002 3:14 AM Subject: Re: Record Lock? Hello. ... With InnoDB you can lock a row by selecting it: SELECT * FROM your_table WHERE some-condition

Re: Record Lock?

Benjamin Pflugmann wrote: Hello. On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote: I would like to lock a specific record in a MySQL table so that no other user can update it while another user is is update the record via the user interface. Can someone please tell me the

Record Lock?

I would like to lock a specific record in a MySQL table so that no other user can update it while another user is is update the record via the user interface. Can someone please tell me the easiest way to do this? Thank you, Richard Reina

Re: Record Lock?

Hello. On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote: I would like to lock a specific record in a MySQL table so that no other user can update it while another user is is update the record via the user interface. Can someone please tell me the easiest way to do this? Depends