----- Original Message ----- > From: "HaidarPesebe" <haidarpes...@gmail.com> > > I asked for help, how to order that each time I add an item then the > item number in column 1 move to column 2, column 2 moves to the > column 3, column 3 to 4 and so on. > > product | 1 | 2 | 3 | 4 | total > [...]
What a most peculiar thing to do :-) You can't have - correction: I don't think you can have column names that start with a digit, so I'll conveniently call them c1 and so on. An update statement is processed in order, so this should work: UPDATE <yourtable> SET c4=c3, c3=c2, c2=c1, c1=<newvalue>, total=c1+c2+c3+c4 WHERE <uniqueidentifierthings>; I would strongly question whether there's no better way to design whatever you're doing, though. /johan -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
