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
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>
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>