MySQL

MySQL Tutorial: Create Database, Table, & Insert Values

Hello World!! In this tiny MySQL Tutorial video, I demonstrate how to create a database, select database, create a table, and insert values into the table, using the terminal, command line, prompt.
How to hash the password in MySQL Database.

How to create a database in MySQL
CREATE DATABASE database_name;
How to list databases in MySQL
SHOW DATABASES;
How to select a database in MySQL
USE database_name;
How to create a table in MySQL
CREATE TABLE table_name(
ID INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
useremail VARCHAR(80) NOT NULL,
userpassword CHAR(50) NOT NULL,
user_created_at TIMESTAMP);

How to insert values in MySQL table
INSERT INTO table_name(username, usermail, userpassword) VALUE('name1', '[email protected]', SHA('secret");

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.