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

Is there a better way to structure post methods in Class Based Views -

reflection - How to access the object-members of an object declaration in kotlin -

php - Doctrine Query Builder Error on Join: [Syntax Error] line 0, col 87: Error: Expected Literal, got 'JOIN' -