Detailed explanation of a method to rename procedure in MYSQL

Detailed explanation of a method to rename procedure in MYSQL

Recently I have used the function of renaming stored procedures. I searched for information on the Internet but couldn't find any information on how to implement it in MySQL. Of course, I can delete it and rebuild it, but there should be other ways. I searched in the "MySQL" database (which comes with it) and found two tables: func and proc. I found that the func table was empty, and the proc table recorded information about procedures and functions.

Try to update the proc table and rename it successfully!

Summarize

The above is a method of renaming procedure in MYSQL introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • How to rename the table in MySQL and what to pay attention to
  • MySQL database rename fast and safe method (3 kinds)
  • Detailed explanation of MySQL event modification events (ALTER EVENT), disabling events (DISABLE), enabling events (ENABLE), event renaming and database event migration operations
  • Rename fields using SQL statements in MySQL
  • MySQL database rename statement sharing
  • Teach you how to use Python to operate MySql database
  • Develop a small tool to operate MySQL using Python
  • Python Basics: Operating MySQL Database
  • Python chat room with interface implementation example code (tkinter, Mysql, Treading, socket)
  • Sharing simple steps of Python operating MySQL database
  • Detailed explanation of the idea of ​​using Python sql statements to perform multi-condition fuzzy queries on mysql database
  • Implementing Add, Delete, Modify and Check in Python with tkinter+MySQL
  • Use Python to quickly rename the MySQL database

<<:  Overview of the Differences between Linux TTY/PTS

>>:  Notes on configuring multiple proxies using vue projects

Recommend

Can't connect to local MySQL through socket '/tmp/mysql.sock' solution

Error message: ERROR 2002: Can't connect to l...

ElementUI component el-dropdown (pitfall)

Select and change: click to display the current v...

Automatically log out inactive users after login timeout in Linux

Method 1: Modify the .bashrc or .bash_profile fil...

In-depth explanation of JavaScript this keyword

Table of contents 1. Introduction 2. Understand t...

MySQL 5.5.27 installation graphic tutorial

1. Installation of MYSQL 1. Open the downloaded M...

Two solutions for automatically adding 0 to js regular format date and time

Table of contents background Solution 1 Ideas: Co...

MySQL 5.7 installation-free configuration graphic tutorial

Mysql is a popular and easy-to-use database softw...

vue element el-transfer adds drag function

The Core Asset Management Project requires el-tra...

How to modify the default network segment of Docker0 bridge in Docker

1. Background When the Docker service is started,...

Solution to the ineffective margin of div nested in HTML

Here's a solution to the problem where margin...

ReactRouter implementation

ReactRouter implementation ReactRouter is the cor...

How to use nginx to build a static resource server

Taking Windows as an example, Linux is actually t...