[sql] A

Viewer

  1. CREATE TABLE `EMPLOYEE` (
  2.         `EMP_Id` INT(11),
  3.         `EMP_Name` VARCHAR(30),
  4.         `Exp_In-Months` INT(20),
  5.         `Monthly_Salary` FLOAT,
  6.         FULLTEXT `EMPLOYEE` (`EMP_Id`,'EMP_Name',`Exp_In-Months`,`Monthly_Salary`) USING BTREE
  7. );
  8. INSERT INTO EMPLOYEE VALUES(1,'Manjesh',30,11000);
  9. INSERT INTO EMPLOYEE VALUES(2,'Raj',10,5000);
  10. INSERT INTO EMPLOYEE VALUES(3,'Johny',15,8000);
  11. INSERT INTO EMPLOYEE VALUES(4,'Joy',12,7000);
  12. INSERT INTO EMPLOYEE VALUES(11,'Pooja',10,46000);
  13. INSERT INTO EMPLOYEE VALUES(20,'Radha',40,46000);
  14. INSERT INTO EMPLOYEE VALUES(5,'Krithi',10,6500);
  15.  
  16.  

Editor

You can edit this paste and save as new: