Re: how to add an auto-increment column to and other column

[marc-antoine yonga]

Hello,

After work, I find a solution, I used a variable with an himself autoincrement and I concat it with an other field.

The code is :

SET @RowNum=0;
SELECT @RowNum:=@RowNum + 1, CONCAT_WS('_', T_Cmde_BaseNumCle2, Convert(@RowNum, Char(7))) from t_jp_commande;

and so the autoincrement is ok and the concat function is ok so you can put each variable of the select query in each field of your table.