Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to set the table to read-only in mysql". In daily operation, I believe many people have doubts about how to set the table to read-only in mysql. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to set table to read-only in mysql". Next, please follow the editor to study!

Setting method: 1, execute the "mysql-u root-p" command and enter the password to log on to mysql;2, use the "use database name;" statement to select the specified database; 3, in the specified database, use the "lock table data table name read;" statement to set the specified data table as read-only.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

MySQL sets the database table to read-only

1. Log in to mysql:

Mysql > mysql-u root-p

2. Select a database

Mysql > use test;Database changed

When the select database statement is executed, if the "Database changed" prompt appears, the selection of the database is successful.

3. Set the table to read-only

Mysql > lock table t_depart_info read;Query OK, 0 rows affected (0.00 sec)

Testing: inserting data

Instruction analysis:

Because t_depart_info is set to read-only and data cannot be inserted into it, the request is being loaded all the time in the screenshot.

At this point, the study on "how to set the table to read-only in mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.