Block some entries. MySql I am newbie in MySql, thus i have very naive question.
I have some database (for example, about hotels). All users may read information about these hotels. Admins are allowed to change this information.
My question is the following: How to block some hotel entry during its modification? In other words if some admin send a query for modification data for hotel1 (it takes time 1-10 secs) all other admins should wait with their modifications of this hotel. Users should see only old information until modification will be complete. 

Million Thanks in advance!
If you are looking for a locking mechanism, You have several options.
For example you may create a new table where you track who is editing and what is being edited. This new table will have an unique key with the fields of "record_edited".

When an administrator starts to edit a hotel detail, you insert a row into this table, and if the result says duplicate entry, then there is somebody already having that record modifying, and tell the admin to wait a little.

If this query returns without error, you then allow the admin to proceed.

When the admin finished with the update on the hotel details, you then remove the "locking record" from the table, and update the hotel details in the database.

Example table for the locking mechanism:

CREATE TABLE `mod_lock` (
 `who_editing` int(11) NOT NULL,
 `record_edited` int(11) NOT NULL,
 UNIQUE KEY `record_edited` (`record_edited`)
)


This method will allow multiple hotel details being edited, while "table lock" will not permit changes to the whole table for the hotel details until the admin finishes with one update.