• notice
  • Congratulations on the launch of the Sought Tech site

Modify the operation tutorial of the library name in mysql

A rename database operation was introduced in 5.1, but this command is not supported after 5.1.23.It can be said to be an experimental feature, not supported in production (mysql-5.1 release in mysql-5.1.30), then in production, we sometimes need to change the library name in order to pursue perfection.How does it work?
Here is a workaround.
1.Create a new library name:

2.Generate a rename statement, migrate from olddb, here I am sbtest in olddb;

3.Execute the generated sql

It's as easy as that.
Good luck!

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

generic atorvastatin & lt;a href="https://lipiws.top/"& gt;purchase atorvastatin pills& lt;/a& gt; buy lipitor 20mg sale

Suqqqz

2024-03-09

Leave a Reply

+