I developed a Web Application and successfully launched it too. But a day after, the client comes up with a problem.In my application, i use a button to generate number(A number used for reference in my project) and i checked it from two digits numbers. But when they gave 9 and after that the value doesnt get incremented from 10.
The Query i used was
SELECT no FROM tbl ORDER BY no ASC;
When i use the query in MySQL Command Line,the value 9 comes at last where the values bigger than this will come at first. Like
Why it happens?
I hope that the sorting wasn't working properly.
Is there any way to fix it?
Never try to be a hard-worker. Be a smart-worker.