SELECT LPAD(rank,3,'0') FROM xxx. SELECT LPAD(rank,3,'*') FROM xxx --012 --*12 如果要用JAVA的話數字補0: String.format( "%03d", 12);//012
確定! 回上一頁