Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

SQL - INSERT INTO Example

Insert records into EMPLOYEE table:

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(101,'John Martin','Team Lead','D01','2001-04-01',75000);
Query OK, 1 row affected (0.08 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(102,'Abraham John','Manager','D02','2001-04-20',70000);
Query OK, 1 row affected (0.08 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(103,'Thomas Abraham','Manager','D03','2002-04-10',80000);
Query OK, 1 row affected (0.07 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(104,'Babu Thomas','Manager','D01','2002-05-01',85000);
Query OK, 1 row affected (0.07 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(105,'Jobin John','Programmer','D01','2002-04-10',50000);
Query OK, 1 row affected (0.09 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(106,'George','Programmer','D01','2002-06-01',45000);
Query OK, 1 row affected (0.12 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(107,'Mathew','Supervisor','D02','2003-04-25',30000);
Query OK, 1 row affected (0.10 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(108,'Mathew Abraham','Supervisor','D02','2003-06-01',20000);
Query OK, 1 row affected (0.04 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(109,'George Mathew','Peon','D02','2004-04-1',10000);
Query OK, 1 row affected (0.17 sec)

mysql> insert into employee (emp_id, emp_name, desig, dept_code, date_join, basic_pay) values(110,'Thomson','Peon','D03','2002-06-01',9000);
Query OK, 1 row affected (0.08 sec)

mysql>

To see the records contained in the EMPLOYEE table:
mysql> select * from employee;
+--------+----------------+------------+-----------+------------+-----------+------+-----------+
| emp_id | emp_name       | desig      | dept_code | date_join  | basic_pay | da   | gross_pay |
+--------+----------------+------------+-----------+------------+-----------+------+-----------+
|    101 | John Martin    | Team Lead  | D01       | 2001-04-01 |  75000.00 | NULL |      NULL |
|    102 | Abraham John   | Manager    | D02       | 2001-04-20 |  70000.00 | NULL |      NULL |
|    103 | Thomas Abraham | Manager    | D03       | 2002-04-10 |  80000.00 | NULL |      NULL |
|    104 | Babu Thomas    | Manager    | D01       | 2002-05-01 |  85000.00 | NULL |      NULL |
|    105 | Jobin John     | Programmer | D01       | 2002-04-10 |  50000.00 | NULL |      NULL |
|    106 | George         | Programmer | D01       | 2002-06-01 |  45000.00 | NULL |      NULL |
|    107 | Mathew         | Supervisor | D02       | 2003-04-25 |  30000.00 | NULL |      NULL |
|    108 | Mathew Abraham | Supervisor | D02       | 2003-06-01 |  20000.00 | NULL |      NULL |
|    109 | George Mathew  | Peon       | D02       | 2004-04-01 |  10000.00 | NULL |      NULL |
|    110 | Thomson        | Peon       | D03       | 2002-06-01 |   9000.00 | NULL |      NULL |
+--------+----------------+------------+-----------+------------+-----------+------+-----------+
10 rows in set (0.00 sec)

mysql>