mysql杂记

授权法
例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。
 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;


如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库，并使用mypassword作为密码
 GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

 FLUSH PRIVILEGES;.

撤销数据库权限
直接删除用户

触发器

DROP TRIGGER IF EXISTS t_afterinsert_on_tab1;
CREATE TRIGGER t_afterinsert_on_tab1
AFTER INSERT ON tab1
FOR EACH ROW
BEGIN
     insert into tab2(tab2_id) values(new.tab1_id);
END;



---开启时间调度
set global event_scheduler=1;

--定义event 每秒插入数据
CREATE EVENT e_test_insert
ON SCHEDULE EVERY 1 SECOND
DO INSERT INTO table VALUES (CURRENT_TIMESTAMP);

--判断是否存在dual 为虚拟表

INSERT INTO user_copy
(id, name, psw)
SELECT UUID(), 'IBM', '123'
FROM dual
WHERE not exists (select * from user_copy
where `name` = 'IBM');