How to set table as read-only in mysql

Setting method: 1. Execute the "mysql -u root -p" command and enter the password to log in 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 to 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 database

mysql> use test;
Database changed

When executing the select database statement, if the "Database changed" prompt appears, it means that the database selection is successful.

3. Set the table to read-only

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

Test: insert data

Command analysis:

• Since t_depart_info is set to read-only, data cannot be inserted into it, so the screenshot is always loading requests...

[Related recommendations ：mysql video tutorial】

The above is the detailed content of How to set table as read-only in mysql. For more information, please follow other related articles on the PHP Chinese website!