From 9ffe961f88aaf93635ea5bb0252d1c1892eb0a10 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 08 五月 2025 17:46:32 +0800
Subject: [PATCH] sql记录
---
ltkj-admin/src/main/resources/sql/无法查到存储过程问题.sql | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git "a/ltkj-admin/src/main/resources/sql/\346\227\240\346\263\225\346\237\245\345\210\260\345\255\230\345\202\250\350\277\207\347\250\213\351\227\256\351\242\230.sql" "b/ltkj-admin/src/main/resources/sql/\346\227\240\346\263\225\346\237\245\345\210\260\345\255\230\345\202\250\350\277\207\347\250\213\351\227\256\351\242\230.sql"
new file mode 100644
index 0000000..4bd5b37
--- /dev/null
+++ "b/ltkj-admin/src/main/resources/sql/\346\227\240\346\263\225\346\237\245\345\210\260\345\255\230\345\202\250\350\277\207\347\250\213\351\227\256\351\242\230.sql"
@@ -0,0 +1,20 @@
+-- 鏌ヨ鎵�鏈夊瓨鍌ㄨ繃绋�
+SELECT db AS routine_schema,
+ name AS routine_name,
+ type AS routine_type,
+ definer
+FROM mysql.proc
+WHERE db = 'ltkjpeis10' AND type = 'PROCEDURE';
+
+
+-- 鑾峰彇鏌ヨ瀛樺偍杩囩▼璇彞鐨剆ql
+SELECT CONCAT('SHOW CREATE PROCEDURE ', db, '.', name, ';') AS create_procedure_statement
+FROM mysql.proc
+WHERE db = 'ltkjpeis10' AND type = 'PROCEDURE';
+
+-- 鍒犻櫎瀛樺偍杩囩▼
+DROP PROCEDURE IF EXISTS ltkjpeis10.xxx;
+-- 鍐嶅垱寤哄瓨鍌ㄨ繃绋�
+
+-- 淇mysql.proc琛�
+mysqlcheck -u root -p --repair mysql proc
--
Gitblit v1.8.0