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 i...
Gmail Tutorials⬇️⬇️
• How to select all emai...
Social Media Tips/Tricks⬇️⬇️
• How to deactivate Face...
JDBC Tutorials⬇️⬇️
• How to connect MySQL w...
Java basic Program⬇️⬇️
• How to find sum of n n...
ArrayList Tutorials⬇️⬇️
• ArrayList in java || i...
java technical/interview program⬇️⬇️
• Java technical/intervi...
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:-
t.me/SSTech624
⏬Twitter:-
sh...
⏬Facebook page
/ shyamsundar624
⏬LinkedIn:-
/ shyam-sundar-yadav-747...
14 окт 2024
