mysql - Not getting leading zero while retrieving from table -
my table containing values in branch code column 0782,kums,0763,khu when select not getting leading zero's output 782,kums,763,khu , need leading 0 also.. mysql query given below
select * candidate_details branch_code = '".$branch_code."'"
please me thanks
set property "zerofill" column.
alter table candidate_details modify branch_code int(5) zerofill;
hope helps.
Comments
Post a Comment