Friends, sorry for the banal question, the number is stored in the database, for example: "0001" field type varchar, I want to increase this number by 1, how to do it?

I need to keep the zeros. Ie 0010, 0111 something like that, in general, that would be preserved zeros.

  • 3
    add as usual and use lpad() to add leading zeros. In general, it’s not a matter of storing numbers in such a format in the database. the format must be set already when issued to the user - Mike
  • one
    thanks for the feature! what you need! - WhoIsDT

0