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

Dear Sir/Madam,

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:

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

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?

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

Yours truly,
Mari=EBn Tino

ViTi =96 Soft & Web Creations
tino [at] viti.be


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


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

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 <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?

Because

<FIRSTVALUE> AND <SECONDFIELD> = <SECONDVALUE>

is legal expression, so your statement is understood as

<FIRSTFILED> = (<FIRSTVALUE> AND <SECONDFIELD> = <SECONDVALUE>)

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

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ 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 [at] m.gmane.org