CREATE table employees(
    emp_id INT  PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(50) NOT NULL,
    lname VARCHAR(50) NOT NULL,
    desig VARCHAR(50) NOT NULL DEFAULT 'Probation',
    dept VARCHAR(50) NOT NULL
);
INSERT into employees (emp_id,fname,lname,desig,dept) VALUES (101,'RAJU','DWIVEDI','Manager','Loan');
INSERT into employees (fname,lname,desig,dept) VALUES ('SHAM','SUNDAR','CASHIER','CASH');
INSERT into employees (fname,lname,desig,dept) VALUES ('PAUL','TIWARI','ASSOCIATE','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('ALEX','MISHRA','ACCOUNTANT','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('VICTOR','TRIPATHI','ASSOCIATE','DEPOSIT');
#SELECT * FROm employees;
SELECT CONCAT_WS('-', 'HII', 'HELLO','NAMSTE','KAISE-HO');

SELECT CONCAT_WS(':',emp_id,fname,lname) from employees;