create  database  userdb;

use userdb;

DROP TABLE IF EXISTS `emp`;

  CREATE TABLE `emp` (

     `id` int(11) NOT NULL,

     `name` varchar(100) DEFAULT NULL,

     `deg` varchar(100) DEFAULT NULL,

     `salary` int(11) DEFAULT NULL,

     `dept` varchar(10) DEFAULT NULL,

      PRIMARY KEY (`id`)

  );

INSERT INTO `emp` VALUES ('1201', 'gopal', 'manager', '50000', 'TP');

INSERT INTO `emp` VALUES ('1202', 'manisha','Proof reader', '50000', 'TP');

INSERT INTO `emp` VALUES ('1203', 'khalil','php dev', '30000', 'AC');

INSERT INTO `emp` VALUES ('1204', 'prasanth','php dev', '30000', 'AC');

 INSERT INTO `emp` VALUES ('1205', 'kranthi','admin', '20000', 'TP');

  

DROP TABLE IF EXISTS `emp_add`;

  CREATE TABLE `emp_add` (

     `id` int(11) NOT NULL,

     `hno` varchar(100) DEFAULT NULL,

     `street` varchar(100) DEFAULT NULL,

     `city` varchar(100) DEFAULT NULL,

     PRIMARY KEY (`id`)

  );

INSERT INTO `emp_add` VALUES ('1201', '288A', 'vgiri', 'jublee');

  INSERT INTO `emp_add` VALUES ('1202', '108I','aoc', 'sec-bad');

  INSERT INTO `emp_add` VALUES ('1203', '144Z','pgutta', 'hyd');

  INSERT INTO `emp_add` VALUES ('1204', '78B','old city', 'sec-bad');

  INSERT INTO `emp_add` VALUES ('1205', '720X','hitec', 'sec-bad');