How to lock a single row

by

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

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. Any way to select without causing locking in MySQL?
  3. How to properly create composite primary keys – MYSQL
  4. Is there a REAL performance difference between INT and VARCHAR primary keys?
  5. What’s the difference between MyISAM and InnoDB? [duplicate]
  6. MySql: MyISAM vs. Inno DB! [closed]
  7. MyIsam engine transaction support
  8. Detecting locked tables (locked by LOCK TABLE)
  9. How can I check MySQL engine type for a specific table?
  10. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  11. How do I lock on an InnoDB row that doesn’t exist yet?
  12. MySQL ‘select for update’ behaviour
  13. Should I always prefer MySQL InnoDB over MyISAM?
  14. Optimistic locking in MySQL
  15. Hierarchical queries in MySQL
  16. #1071 – Specified key was too long; max key length is 1000 bytes
  17. MySql Error 150 – Foreign keys
  18. Add Auto-Increment ID to existing table?
  19. Using group by on two fields and count in SQL
  20. How do I get the first day of the week of a date in mysql?
  21. Meaning of “n:m” and “1:n” in database design
  22. How to force case sensitive table names?
  23. MySQL concat() to create column names to be used in a query?
  24. How to delete duplicate records in mysql database?
  25. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  26. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  27. Order by FIELD in MYSQL
  28. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  29. How to pass a variable to a IN clause?
  30. Insert and set value with max()+1 problems

Leave a Comment