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;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly