Create a Simple Database Schema

Question 1

Create a Simple Database Schema

Answer 1

On mariadb server

mysql -u root -p

SHOW DATABASES;

USE MYSQL;

SHOW TABLES;

SELECT * FROM host;

DESCRIBE host;

CREATE DATABASE emails;

SHOW DATABASES;

USE emails;

CREATE TABLE users (userID INT, userFirstName char(25), userLastName char(30), userEmailAddress char(50));

SHOW TABLES;

SELECT * FROM user;