How can i use variables in 'update' statments ? - ROMEO PETRUCA - com.mysql.lists.win32

2 messages in com.mysql.lists.win32How can i use variables in 'update' s...

From	Sent On	Attachments
ROMEO PETRUCA	21 Jul 2005 01:49
Petr Vileta	21 Jul 2005 05:22

Subject:	How can i use variables in 'update' statments ?
From:	ROMEO PETRUCA (rpet...@yahoo.com)
Date:	07/21/2005 01:49:08 AM
List:	com.mysql.lists.win32

set @month='05'; set @year='2005'; set @table=concat('table',@month,@year);

and i want this:

update table052005 set........

but something like this

update @table set.........

some answers ???