Full stack tech reference blogs by Tirumal Sutrave

Create Database    create database <Database Name>; Selecting a Database   Use <Database Name>; List all tables in Database   show tables; Create User table CREATE TABLE USER ( ID int NOT NULL, NAME varchar(100) NOT NULL, EMAIL_ADDRESS varchar(100), PRIMARY KEY (ID) ) Or  CREATE TABLE USER ( ID int NOT NULL AUTO_INCREMENT, NAME varchar(100) NOT NULL, EMAIL_ADDRESS varchar(100) NOT NULL, SALARY double DEFAULT NULL, NOTE text, PRIMARY KEY (ID) )

Assumption :      You have MariaDB and Client installed. Steps:      Run client and create database using command "create database".       create database test;      Now, connect to that database using "USE" command       Use test;      Create new table USER with following command       CREATE TABLE USER (       ID int NOT NULL,       NAME varchar(100) NOT NULL,       EMAIL_ADDRESS varchar(100),       PRIMARY KEY (ID)       )      Now, download the driver from mysql site. I'm using "mysql-connector-java-5.1.46". MySql and MariaDB are similar so for basic connectivity mysql drivers works. Class.forName("com.mysql.jdbc.Driver"); java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "password"); Prepare...