How to lock a single row

mysql locking myisam
svk picture svk · Oct 7, 2010 · Viewed 63.2k times · Source

I have a user table with field lastusedecnumber.

I need to access and increment lastusedecnumber.

During that accessing time I need to lock that particular user row (not the entire table).

How do I do this?

The table type is MyISAM.

Answer

belwood picture belwood · Oct 7, 2010

MySQL uses only table-level locking from MyISAM tables. If you can, switch to InnoDB for row-level locking.

Here's a link to the MySQL site describing Locks set by SQL Statements for InnoDB tables. http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html

Related questions

MySQL MyISAM table locking

Does a MySQL MyISAM table gets locked when records are deleted from it?

Read More
mysql replication - table locking?

I am currently working for a company that has a website running mysql/php (all tables are also using the MYISAM table type). We would like to implement replication, but I have read in the mysql docs and elsewhere on …

Read More
Any way to select without causing locking in MySQL?

Query: SELECT COUNT(online.account_id) cnt from online; But online table is also modified by an event, so frequently I can see lock by running show processlist. Is there any grammar in MySQL that can make select statement not …

Read More