mysql LOCK TABLES

Published: 28 December 2022
on channel: spa it

109

CREATE USER 'spa1'@'localhost' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON . TO 'spa1'@'localhost' WITH GRANT OPTION; (не робіть так)
FLUSH PRIVILEGES;

SELECT user FROM mysql.user;

одне вікно
sudo mysql -uspa1 -p123
інше вікно
sudo mysql

show processlist;
USE base2
SELECT * FROM Customers;

INSERT Customers(Age, FirstName, LastName)
VALUES (45,'Olga','Vanetsko');

WRITE - процес, який викликав блокування, може читати та писати, інші курять.
для root
LOCK TABLES Customers WRITE;

INSERT Customers(Age, FirstName, LastName)
VALUES (45,'Olga','Vanetsko');

для spa1
show processlist;

SELECT * FROM Customers;

для root
UNLOCK TABLES;

INSERT Customers(Age, FirstName, LastName)
VALUES (45,'Olga','Vanetsko');

READ - все(як процес, і інші) можуть лише читати.
LOCK TABLES Customers READ;

INSERT Customers(Age, FirstName, LastName)
VALUES (45,'Olga','Vanetsko');

SELECT * FROM Customers;

UNLOCK TABLES;

Watch video mysql LOCK TABLES online without registration, duration hours minute second in high quality. This video was added by user spa it 28 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 109 once and liked it 3 people.

25,220,678

1.7M