Working with mysql in phpmyadmin or?

Question

PHP

Hello everyone. I’m reading a book on php and mysql, and the mysql section has come, as I understand it, they used to administer the database through commands entered manually, and now there are all sorts of helpers like phpmyadmin (it’s not there about it). I haven’t started yet, I wanted to ask, it’s better just learn phpmyadmin quickly and read more php or ? In order not to suffer from installations, I work through openserver there and found phpmyadmin. Thanks in advance for the answers and MB advice.

Answer 1

Learn the SQL language and the dialect used in MySQL (in general, this is the same process if you are not drawn to other DBMS). Generating requests is certainly great, but it's better to understand what and how the request makes. Of course, you can also generate tables with the mouse - it's even faster than writing, but surprises are possible.

Answer 2

Your book is strange, pma has definitely existed for 15 years.
Well, in the case - often pma is enough with the head, and almost all hostings have it. But just in case, you also need to be familiar with console mysql - because sometimes it is easier to make / upload a large dump through the console utility.

Answer 3

I would advise heidisql ..
autocomplete is still a handy thing

Answer 4

Learn commands, repeat actions in PMA - there they are displayed on the screen, you'll figure it out.

Answer 5

Instead of phpmyadmin I recommend using adminer . The alternative is more lightweight, but no less functional because of this, there is support for other DBMS.