My MySQL is part of the package that came when I loaded Xammp so there is a phpMyAdmin [not the command lines features you use]. How can I/What do I need to do in order to be able to enter the command lines in the fashion that you do. I would like to use both the MyAdmin but want to take advantage of the skills you are demonstrating in your video. Regards.

You can access the console version of MySQL with Xammp. Look for the folder like this c:\xampp\mysql\bin
and then execute mysql.exe -u root. You can also put it in your path so you can access it outside of that folder.