其他
文章平均质量分 72
he25819
这个作者很懒,什么都没留下…
展开
-
mysql函数(task_view)
CREATE DEFINER=`root`@`%` PROCEDURE `task_view_rebuild`() BEGIN DECLARE odr INT DEFAULT 1; DECLARE idx INT DEFAULT 1; DELETE FROM task_view; WHILE ((SELECT COUNT(*) FROM task WHERE id=idx) > 0 AND (SELECT COUNT(*) FROM task_view) < 1000) DO原创 2020-12-21 11:11:27 · 128 阅读 · 0 评论 -
auto backup mysql自动备份mysql数据库
#!/bin/bash # Auto backup mysql database # by hexw DB_CMD=/usr/local/mysql/bin/mysqldump DB_USR=root DB_PSW=??? DB_DB=hlw2_sdata BAK_DIR=/home/astd/backup/$DB_DB if [ ! -d $BAK_DIR ];then mkdir -p $BAK_DIR fi if [ $UID -ne 500 ];then echo "Must use as原创 2020-12-02 13:41:20 · 191 阅读 · 0 评论