Create a Simple Database Schema Flashcards Preview

RHCE > Create a Simple Database Schema > Flashcards

Flashcards in Create a Simple Database Schema Deck (1):
1

Create a Simple Database Schema

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;