05 2019 档案

批量修改mysql数据库引擎
摘要：SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;' )FROM information_schema.tablesWHERE table_schema = 'lct-agent-test' and ENGINE!='InnoDB' 阅读全文
posted @ 2019-05-23 15:30 MisMe 阅读(307) 评论(0) 推荐(0)
mysql表名批量修改为大/小写
摘要：DELIMITER // DROP PROCEDURE IF EXISTS uppercase // CREATE PROCEDURE uppercase(IN dbname VARCHAR(200)) BEGIN DECLARE done INT DEFAULT 0; DECLARE oldnam 阅读全文
posted @ 2019-05-15 11:37 MisMe 阅读(1844) 评论(0) 推荐(0)