dear sir this my blow mysql stored procedure for generate Ticket in sequence like example
#ticket00001
in this stored procedure i am getting result
this #ticket2 insted of #ticket00002
i need my next result should be proper
CREATE DEFINER=`root`@`localhost` PROCEDURE `spGenerateTicket`()
BEGIN
declare fixname varchar(10);
declare oldTicket varchar(15);
declare numId int ;
declare newTicket varchar(45);
-- declare newIntId int ;
if exists (select TicketNo from tbl_ticketmaster order by TicketNo desc limit 1) then
begin
set fixname = '#ticket';
set oldTicket = (select TicketNo from tbl_ticketmaster order by TicketNo desc limit 1);
-- set numId = (select oldTicket , SUBSTRING_INDEX(oldTicket,'t',-1));
-- set numId = (select SUBSTRING_INDEX(oldTicket,'t',-1) as numPart);
set numId = (select SUBSTRING_INDEX(oldTicket,'t',-1) as numPart);
set newTicket = (select concat(fixname,'',numId+1));
select newTicket;
end ;
else
insert into TicketNo values (null , '#ticket0001');
end if;
END