I have been reading up on MYSQL Variables and wanted to know how and when to set a mysql variable and how it is access in relation to carrying out SQL statements
Firstly i was trying to determing whether or not this is a MYSQL 5 feature which i dont have
Secondly Im trying to use this set variable option in an updating statement
Code: Select all
SET @Pos = 1; UPDATE cms_menu_test SET NavOrder = (@Pos+$position),@Pos:=(@Pos+1) WHERE MenuGroup = '$menuGroup'How do you use this and when is it accessible
Kendall