| |

VerySource

 Forgot password?
 Register
Search
View: 39|Reply: 3

How does mysql modify the database name?

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 United States

Post time: 2020-2-7 15:00:01
| Show all posts |Read mode
alter database 'a' modify name = 'bb';
No way

sp_renamedb, not working in mysql

Master, give me pointers! Thank you
Reply

Use magic Report

0

Threads

15

Posts

12

Credits

Newbie

Rank: 1

Credits
12

 China

Post time: 2020-4-3 21:45:01
| Show all posts
Delete and create
Reply

Use magic Report

1

Threads

6

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 China

Post time: 2020-4-16 19:30:01
| Show all posts
ALTER {DATABASE | SCHEMA} @var {db_name}
    @var {alter_specification} [, @var {alter_specification}] ...
Reply

Use magic Report

0

Threads

15

Posts

12

Credits

Newbie

Rank: 1

Credits
12

 China

Post time: 2020-5-6 16:45:01
| Show all posts
This will do:
Backup mysqldump -u root -ppwd databasename> c:\database.sql
  Restore mysql -u root -ppwd newdatabasename <c: /database.sql
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list