General Information
Creating a simple database in MariaDB.
The following virtual machines will be used:
Previous Section Completed
Connect to the database
mysql -u root -p
Show databases available
MariaDB [(none)]> SHOW DATABASES;
Open a database
MariaDB [(none)]> USE mysql;
Display tables in the database
MariaDB [(mysql)]> SHOW TABLES;
Display all (SELECT *) contents of the table 'host'
MariaDB [(mysql)]> SELECT * FROM host;
Show details of the table 'host'
MariaDB [(mysql)]> DESCRIBE host;
Create a database called 'emails'
MariaDB [(none)]> CREATE DATABASE emails;
Open the new database
MariaDB [(none)]> USE emails;
Create a new table in the emails database
MariaDB [emails]> CREATE TABLE users (userID INT AUTO_INCREMENT PRIMARY KEY, userFirstName CHAR(50), userLastName CHAR(50), userEmailAddress CHAR(50)) AUTO_INCREMENT = 100;
Show the tables in the emails DB, display contents of the users table, show the data types in the users table.
MariaDB [emails]> SHOW TABLES; MariaDB [emails]> SELECT * FROM users; MariaDB [emails]> DESCRIBE users;