How to perform integer arithmetic to a string in MySQL?

Question

I need to increase a value by 1 in MySQL that isn't saved as an Integer: It is saved instead as a String because it may start with a 0, for instance: 01212120211112. I want to set this value to 01212120211113.

The "number" is always 14 char long (including the 0 on the beginning) and it will never get longer or shorter.

I want to convert it to an Integer
set it + 1
Convert back to String
add a 0 to begin til a length of 14 chars.

Can anyone help me with the syntax?

Check this out.

Sterconium
– Sterconium

2019-11-11 10:58:26 +00:00
Commented Nov 11, 2019 at 10:58 — Sterconium
– Sterconium, Commented Nov 11, 2019 at 10:58

ScaisEdge · Accepted Answer · 2019-11-11 10:52:47Z

1

Do the fact you have always a fixed length string You could use convert .. and lpad see the various function in sample

 select CONVERT('01212120211112',UNSIGNED INTEGER)

.

 select CONVERT('01212120211112',UNSIGNED INTEGER) + 1

.

 select lpad(CONVERT('01212120211112',UNSIGNED INTEGER) + 1 , 14, '0')

answered Nov 11, 2019 at 10:52

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to perform integer arithmetic to a string in MySQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related