How can I change my existing database name?

0 votes
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?
Jul 4, 2019 in Database by partha
71 views

1 answer to this question.

0 votes

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,

answered Jul 4, 2019 by sampriti
• 1,100 points

Related Questions In Database

0 votes
1 answer
0 votes
1 answer

How can I connect databases server to EC2 server?

Hi@Trinu, You can create one database in AWS ...READ MORE

answered May 1 in Database by MD
• 41,340 points
59 views
0 votes
1 answer

How can Mysql database sync between two databases?

Hii, Some simple rules you will have to ...READ MORE

answered May 4 in Database by Niroj
• 43,540 points
53 views
0 votes
1 answer

How to set SSL to Domain name for MYSQL database

Hello @ Lakshminarayanan, Yes, It is possible to setup ...READ MORE

answered Jul 9 in Database by Niroj
• 43,540 points
54 views
+1 vote
1 answer

How can I reset my auto_increment column in MYSQL?

Hi Pratim, I understand your issue. I think you ...READ MORE

answered Jul 1, 2019 in Database by sampriti
• 1,100 points
118 views
0 votes
1 answer

Is it possible to access Couchbase by terminal?

What you want to accomplish isn't possible ...READ MORE

answered Apr 29, 2018 in DevOps & Agile by DareDev
• 6,850 points
84 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
• 4,630 points
410 views
0 votes
1 answer
0 votes
1 answer

How can I check my all existing table in MySQL database?

Hi Pratik, I understand your problem regarding this ...READ MORE

answered Jul 1, 2019 in Database by sampriti
• 1,100 points
139 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,100 points
116 views