Disclaimer: TubeMint is fully funded by its readers, we recommend hightly rated affiliate products and services and when you buy them through our links, we get commission at no extra cost to you. Thanks for you support!

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