Hướng dẫn tạo database bằng command line

/opt/lampp/bin/mysql -u root
link: https://askubuntu.com/questions/95241/how-do-i-start-the-mysql-console-in-xampp
MariaDB [(none)]> show databases;
create database tintuc_shopdunk;
MariaDB [(none)]> show databases;

Xem database đã tạo:
MariaDB [dvd]> describe customers;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| customer_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name        | varchar(60)      | NO   |     | NULL    |                |
| address     | varchar(60)      | NO   |     | NULL    |                |
| city        | varchar(60)      | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+