Hello,

Does mySql support the FOR UPDATE clause as in SELECT * FROM table WHERE criteria FOR UPDATE ? The manual talks about FOR UPDATE as if it is supported but I am getting syntaxis error messages for it. I am using mySql-3.23.33 on windows. The statement is issued from within a Java program using org.mm.mysql.Driver jdbc driver. Regardless the statement does not work from mysql commandline anyway, but I could imagine this has to do with the fact that FOR UPDATE doesn't make any sense in that context. Anybody ?

Thanks, Unico