mysql
柴智霖
这个作者很懒,什么都没留下…
展开
-
SQLException: Access denied for user ‘root‘@‘localhost‘
可能是本地连接未设置密码连接项,运行以下命令: ssh mysql mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql> FLUSH PRIVILEGES;原创 2021-06-01 15:58:30 · 168 阅读 · 0 评论 -
mysql 存储过程实例 动态表名 if判断
DROP PROCEDURE IF EXISTSCountSkyDDSAuditByMonth;DELIMITER //CREATE PROCEDURE CountSkyDDSAuditByMonth( INtableName VARCHAR(64), INinsertType VARCHAR(6) )BEGINDECLARE totalMsg,totalMs...原创 2018-06-07 11:19:02 · 776 阅读 · 0 评论 -
MySQL job 定时任务
DROP EVENT IF EXISTS JOB_COUNT; CREATE EVENT JOB_COUNT ONSCHEDULE EVERY 10 MINUTE DO BEGIN IF(date_format(current_time(),'%H')=0) THEN CALL CountSkyDDSAuditByDay('skydds_transfer_log_cou...原创 2018-06-07 11:20:18 · 1396 阅读 · 0 评论