Create Table LEAVE_MASTER(
ID int auto_increment,
USER_ID nvarchar(20) not null,
USER_NAME nvarchar(20) not null,
LEAVE_BALANCE float(10),
LEAVE_APPLIED float(10),
LEAVE_PENDING float(10),
Constraint PK_KEY primary key(ID),
FOREIGN KEY (USER_ID) references user_master(USER_ID)
);

INSERT INTO LEAVE_MASTER (ID, USER_ID, USER_NAME, LEAVE_BALANCE, LEAVE_APPLIED, LEAVE_PENDING)
VALUES (FLOOR(RAND()*1000), CONCAT(‘User_’, FLOOR(RAND()*1000)), FLOOR(RAND()*50), FLOOR(RAND()*10), FLOOR(RAND()*5));

I am trying to generate random records in the table LEAVE_MASTER