Create a Simple Database Schema Flashcards
1
Q
Create a Simple Database Schema
A
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;