Close: MySQL update query to increment specific value

Question

How to update mysql column Id name with same value increment update A (expected) update B (expected) 1AAAAA112AAAAA123AAAA134BBBBB215BBBBB226CCCCC317CCCCC328CCCCC339CCCC3410CCCC35

P粉105971514 · Answer

Your question is unclear.

If necessary, you can do this:

UPDATE whatever_table 
   SET column_a = column_a + 1
 WHERE column_name = 'AAAAAA'

This will increment a column in a ACID compliant manner.

Id	name	UpdateA(expected)	Update B (expected)
1	AAAAA	1	1
2	AAAAA	1	2
3	AAAAA	1	3
4	BBBBB	2	1
5	BBBBB	2	2
6	CCCCCC	3	1
7	CCCCCC	3	2
8	CCCCCC	3	3
9	CCCCCC	3	4
10	CCCCCC	3	5