[sql] A
Viewer
- CREATE TABLE `EMPLOYEE` (
- `EMP_Id` INT(11),
- `EMP_Name` VARCHAR(30),
- `Exp_In-Months` INT(20),
- `Monthly_Salary` FLOAT,
- FULLTEXT `EMPLOYEE` (`EMP_Id`,'EMP_Name',`Exp_In-Months`,`Monthly_Salary`) USING BTREE
- );
- INSERT INTO EMPLOYEE VALUES(1,'Manjesh',30,11000);
- INSERT INTO EMPLOYEE VALUES(2,'Raj',10,5000);
- INSERT INTO EMPLOYEE VALUES(3,'Johny',15,8000);
- INSERT INTO EMPLOYEE VALUES(4,'Joy',12,7000);
- INSERT INTO EMPLOYEE VALUES(11,'Pooja',10,46000);
- INSERT INTO EMPLOYEE VALUES(20,'Radha',40,46000);
- INSERT INTO EMPLOYEE VALUES(5,'Krithi',10,6500);
Editor
You can edit this paste and save as new: