how to create database & table in MySql || Shyam Sundar

Опубликовано: 18 Май 2026
на канале: Programming By Shyam Sundar

create database interview;
use interview;
show tables;

CREATE TABLE EmployeeDetail (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Gender CHAR(1) NOT NULL,
JoiningDate DATE NOT NULL,
Department VARCHAR(100),
Salary DECIMAL(10, 2) NOT NULL
);

INSERT INTO EmployeeDetail (
EmployeeID, FirstName, LastName, Gender, JoiningDate, Department, Salary
) VALUES
(1, 'John', 'Doe', 'M', '2010-01-15', 'Software Engineer', 85000.00),
(2, 'Jane', 'Smith', 'F', '2012-03-12', 'Project Manager', 92000.00),
(3, 'Bob', 'Johnson', 'M', '2008-11-05', 'Accountant', 78000.00),
(4, 'Alice', 'Williams', 'F', '2015-08-01', 'HR Specialist', 67000.00),
(5, 'David', 'Brown', 'M', '2005-05-20', 'Senior Developer', 95000.00);

HTML Tutorials⬇️⬇️
   • html tutorials

Data Conversion in Java⬇️⬇️
   • Converting String to int data type in java...

Gmail Tutorials⬇️⬇️
   • How to select all emails in Gmail || in hi...

Social Media Tips/Tricks⬇️⬇️
   • How to deactivate Facebook account || in h...

JDBC Tutorials⬇️⬇️
   • How to connect MySQL with java program || ...

Java basic Program⬇️⬇️
   • How to find sum of n numbers in java || in...
ArrayList Tutorials⬇️⬇️
   • ArrayList in java || introduction || examp...

java technical/interview program⬇️⬇️
   • Java technical/interview programs

java string methodprogram⬇️⬇️
   • Java String method

java swing program⬇️⬇️
   • Swing Tutorials

java pattern porgram⬇️⬇️
   • Pattern program

java matrix program⬇️⬇️
   • matrix program

follow us on social media:-

⏬instagram:-
  / shyamsundar624

⏬Telegram:-
https://t.me/SSTech624

⏬Twitter:-
https://twitter.com/shyamsundar624?s=09

⏬Facebook page
  / shyamsundar624

⏬LinkedIn:-
  / shyam-sundar-yadav-747884192