Problem of storing employee id in mysql??????

Simply you can generate e separately, then you can generate the numbers 1,2,3 separately and simply can join them as we do in excel with CONCATENATE function. Hope it helps