Employee table in SQL

Let’s see the normalized emp table in SQL.

Database: t4tutorials,  Table: departments

Dept_Num Dept_Name Dept_City
1 CS Islamabad
2 SE CALIFORNIA

Database: t4tutorials,  Table: employee

Emp_N

o

Emp_Na

me

Emp_Mobile

No

Emp_Email Emp_Addr

ess

1 ALI 33333 [email protected] Pakistan
2 Asad 333333334 [email protected] United States

Database: t4tutorials,  Table: mp_department

DepID Emp_No Dept_Num
1 1 1
2 2 2
Employee table in SQL
Employee table in SQL

Creating employee table in MySQL

Execute this query to auto-create tables in MYSQL

Inserting data into employee table in MySQL

Execute this query to auto-insert data in  tables using MYSQL.

Similarly, you can insert data into all tables, by simplifying modifying queries or by using the end-user interface of your tool.

Download emp table in SQL

Database tables in SQL

  1. Student table in SQL
  2. Employee table in SQL
  3. Product table in SQL
Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.