UPDATE statement

"Tino Mariën \(ViTi\)" <[email protected]> Tue, 12 Aug 2003 09:50:19 +0200

Newsgroups	gmane.comp.db.mysql.bugs
Message-ID	<[email protected]>

Dear Sir/Madam,
 
Ive got a very annoying problem with the UPDATE statement.
Im 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 dont 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
 
ViTi  Soft & Web Creations
[email protected]
 
 
PS: Im very satisfied by your product, thumbs up