How can I change my existing database name

Question

Hey,

All time I drop my database whenever I need to change the name . But this time I want to rename database name.

How can I do that?

Answer 1

Hey Partha,

I understand your problem,

I think this query will work for you

RENAME TABLE old_db.table TO new_db.table;

Please check with this query

Thank you,