SQL phpmyadmin - Rename database -


i created fresh database in phpmyadmin not contain tables yet since fresh, accidentally made typo. how can rename database?

if happens me execute sql command:

drop database dbname; 

and create database. possible rename it? searching found nothing helpful.

i found 2 possible solutions.

  1. rename via phpmyadmin backend ui (preferable):

enter image description here

enter image description here

  1. or execute sql (only use if database fresh , not contain data yet, otherwise lost!)

    create database newname;

    drop database oldname;


Comments

Popular posts from this blog

python - Creating a new column in a dataframe based on the result of the addition of three others -

string - Using python and postgres, variables within execute function? -