DELIMITER $$
CREATE TRIGGER trigger_name
BEFORE DELETE
ON table_name
FOR EACH ROW
BEGIN
if SUBSTRING_INDEX(USER(),'@',1) NOT IN ('root') THEN
CALL cannot_delete_error;
END if;
END
$$
Subscribe to:
Post Comments (Atom)
Gitlab_CICD_Sample Deployment
Gitlab CICD Stages: build - Create build of project. - If it is docker project which contains dockerfile then, create docker image - push in...
-
an authentication error has occurred the token supplied to the function is invalid I have installed xrdp 0.9.8 at server side. Re...
-
Epson LQ 300 Printer Driver for Linux (Dot Matrix Printer) 1. Download the ppd file from the below link https://drive.google.com/file/d/...
-
First check partition type of existing disk. parted -l To convert MBR to GPT, create one partition with gpt and that will convert entire...
No comments:
Post a Comment