Enter mariadb via command line after installing XAMPP on Windows

Digression: Read "MySQL must know will", the book Let me find a database server practiced hand, I went to a xampp, because of the 08-year NetEase on the dynamic website development, that time xampp in the M for MySQL, and later through the command line into the MySQL appeared: Welcome to MariaDB ... Thought again out of the moth, and later found that, because MySQL was acquired by Oracle after the possibility of closed source, MySQL author also made a mariadb, named after his daughter ... Oracle is crying ... But it's still compatible with MySQL.

Start MySQL on XAMPP's control panel

Configure environment variables: Add C:\xampp\mysql\bin, Win+r, cmd Enter, mysql-u root-p Enter password (if it is the first time, direct enter, default password "")

The following commands are followed:

SHOW DATABASES; Show available Databases
Use first_db;  Use the database
SHOW TABLES; Show all tables for this database
Show COLUMNS from table name//Display table column

Enter mariadb via command line after installing XAMPP on Windows