Dear Sir/Madam,

I’ve got a very annoying problem with the UPDATE statement. I’m using ASP.NET, MySQL and for the connection I use the Microsoft.Data.ODBC reference. A couple of times I typed the UPDATE statement look the following:

UPDATA <TABLE> SET <FIRSTFILED> = <FIRSTVALUE> AND <SECONDFIELD> = <SECONDVALUE> WHERE

Off course, the statement is incorrect, while ‘AND’ must be replaced by ‘,’ but I don’t get any error , why is that?

When can we expect a version of MySQL that includes stored procedures, It would be a great asset to your product!

Yours truly, Mariën Tino

PS: I’m very satisfied by your product, thumbs up