Create table in Error

You need to tell SQL which table the foreign key refers to:

EMP_ID int NOT NULL foreign key REFERENCES empDetails,

BTW, the would be a good idea to declare both keys to be the same size - if you explicitly state int(11) for one, your should also use int(11) for the foreign key rather than just int

First of all INT(11) is INVALID, You can't specify the column length on the data type INT..

CREATE TABLE empDetails (
EMP_ID int primary key NOT NULL,
password varchar(10) NOT NULL
);


CREATE TABLE LEAVE_DETAILS_ADMIN (
EMP_ID int NOT NULL foreign key references empDetails(EMP_ID) ,
leaveEarnedCredit float(2),
leaveCasualCredit float(2),
leaveMaternityCredit float(2)
);


try this, Hop will works fine,....

All the Best:-)