Taking it
Testing
Sample Java Login application uses "UserDB" database and Table schema to store the Employee Login details.
SHOW DATABASES;
CREATE DATABASE UserDB;
USE UserDB;
SHOW TABLES;
CREATE TABLE Employee ( id int unsigned auto_increment not null, first_name varchar(250), last_name varchar(250), email varchar(250), username varchar(250), password varchar(250), regdate timestamp, primary key (id) );
SELECT * FROM Employee;
DESCRIBE Employee;