01 2020 档案

批量修改表前缀
摘要：SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO db_', substring(table_name, 4), ';' ) FROM information_schema. TABLES WHERE table_name LIKE 'ct 阅读全文
posted @ 2020-01-28 16:46 磊~哥 阅读(171) 评论(0) 推荐(0)
mysql 删除以某字符串开头的表
摘要：Select 'SET FOREIGN_KEY_CHECKS = 0;'unionSelect CONCAT( 'drop table ', table_name, ';' )FROM information_schema.tablesWhere table_name LIKE 'as_baiqis 阅读全文
posted @ 2020-01-27 16:35 磊~哥 阅读(2422) 评论(0) 推荐(0)
linux清理缓存以及清理时候遇到的问题
摘要：运行下面语句清缓存时，报Permission denied错误：-bash: /proc/sys/vm/drop_caches: Permission denied sudo echo 1 > /proc/sys/vm/drop_caches sudo echo 2 > /proc/sys/vm/d 阅读全文
posted @ 2020-01-04 16:48 磊~哥 阅读(4310) 评论(0) 推荐(0)