UPDATE statement

am 12.08.2003 09:50:19 von tino

------=_NextPart_000_0001_01C360B7.25E74120
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Sir/Madam,
=20
I=92ve got a very annoying problem with the UPDATE statement.
I=92m 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:
=20
UPDATA

SET =3D AND =3D
WHERE =85
=20
Off course, the statement is incorrect, while =91AND=92 must be replaced =
by
=91,=92 but I don=92t get any error , why is that?
=20
When can we expect a version of MySQL that includes stored procedures,
It would be a great asset to your product!
=20
Yours truly,
Mari=EBn Tino
=20
ViTi =96 Soft & Web Creations
tino@viti.be
=20
=20
PS: I=92m very satisfied by your product, thumbs up
=20

------=_NextPart_000_0001_01C360B7.25E74120--

Re: UPDATE statement

am 12.08.2003 10:41:00 von Sergei Golubchik

Hi!

On Aug 12, Tino Mariën (ViTi) wrote:
> 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

SET = AND =
> WHERE ?
>
> Off course, the statement is incorrect, while ?AND? must be replaced by
> ?,? but I don?t get any error , why is that?

Because

AND =

is legal expression, so your statement is understood as

= ( AND = )

So, your statement is syntaxically correct, even if it does not do what
one would expect :)

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org