Re: "SET field=field+1" no longer works?
Stewart, > All you should have to do is wrap the statement in () like: > UPDATE SET field=(field+1) WHERE I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html). Where did you find the requirement for parentheses? Do you have live code where UPDATE works with parentheses, but fails without them? Please advise, =dn PS with regard to your question about the original post, Tyler's problem was elsewhere and has been solved. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "SET field=field+1" no longer works?
Hi Tyler, Apologies for the absence/delay. Pleased to hear that the problem is solved. It does raise the question though - if it failed in PHP (etc) how did you manage to get it to work in MySQL-client? If an UPDATE flat refuses to go (which didn't seem to be the case here), then the first 'check' should be to substitute/paste the WHERE clause into a SELECT query. As it turns out, that would have highlighted the problem for you! Regards, =dn > This was my bad. I forgot that I had encoded all passwords with > base64_encrypt() in PHP. So, the passwords in the database weren't in their > plaintext forms. So, my password wasn't matching up with what was in the > database. > > Everything works good now. :) > > Thanks for your help! > tyler > > - Original Message - > From: "Stewart Gateley" <[EMAIL PROTECTED]> > To: "Tyler Longren" <[EMAIL PROTECTED]>; "DL Neil" > <[EMAIL PROTECTED]> > Cc: "MySQL List" <[EMAIL PROTECTED]> > Sent: Tuesday, February 26, 2002 5:56 PM > Subject: Re: "SET field=field+1" no longer works? > > > > Try: > > > > UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND > > password='myfakepassword'; > > > > > > I am using > id=$id"); ?> and it works fine. > > > > -- Stewart > > > > --- Tyler Longren <[EMAIL PROTECTED]> wrote: > > > Well, here's the query that PHP is generating: > > > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND > > > password='myfakepassword' > > > > > > If I copy and paste that exactly into the mysql client, it's executed > > > correctly. If I use phpMyAdmin to execute it, it IS NOT executed > > > correctly > > > (same as in my PHP code). I really don't think this is a problem > > > with my > > > coding since it worked with previous versions of mysql. Could PHP > > > just be > > > screwing up while sending the query to MySQL? > > > > > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get > > > executed properly. It only works correctly when issuing the query > > > from the > > > mysql command line client. :) > > > > > > Tyler > > > > > > - Original Message - > > > From: "DL Neil" <[EMAIL PROTECTED]> > > > To: "Tyler Longren" <[EMAIL PROTECTED]> > > > Cc: <[EMAIL PROTECTED]> > > > Sent: Tuesday, February 26, 2002 8:52 AM > > > Subject: Re: "SET field=field+1" no longer works? > > > > > > > > > > Hi Tyler, > > > > [back on-list so that others can offer their wisdom!] > > > > > > > > OK, so it's not a problem with the MySQL client, then it's likely > > > the PHP. > > > Most likely that the username and > > > > password data values are strings and need to be properly contained > > > with > > > single- or double-quotation marks. > > > > > > > > If you need further assistance, first try some debug ECHOs on the > > > three > > > fields used in the query, and ECHO the > > > > query itself immediately prior to the call to MySQL. (is the last > > > how you > > > posted (copy-pasted) the query into > > > > the MySQL client, or did you type it into MySQL by hand?) > > > > > > > > If lights still don't go off, please post the PHP code snippet. > > > > > > > > Regards, > > > > =dn > > > > > > > > > > > > > I tried it in PHP first, and it doesn't work in that. But, when > > > I use > > > the > > > > > mysql client, it works as expected. Any ideas? > > > > > > > > > > > > > > Hello Tyler, > > > > > > > > > > > > Did someone pick up this question - haven't spotted a response > > > on the > > > > > list? > > > > > > I haven't spotted any such mis-behavior under either Win2000 or > > > WinNT. > > > > > > > > > > > > Are you entering the query at the command line or into some > > > tool? > > > > > > Have you tried another client? > > > > > > > > > > > > If it is still unresolved, send me (NOT the whole list) the > > > actual &g
Re: "SET field=field+1" no longer works?
I no longer have the original post in my inbox, I had a problem with fetchmail which downloaded all the messages a couple hundred times, so i did a mass delete. All you should have to do is wrap the statement in () like: UPDATE SET field=(field+1) WHERE This will work fine from PHP using something like Hope this helps you, Stewart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "SET field=field+1" no longer works?
Hi Everyone, This was my bad. I forgot that I had encoded all passwords with base64_encrypt() in PHP. So, the passwords in the database weren't in their plaintext forms. So, my password wasn't matching up with what was in the database. Everything works good now. :) Thanks for your help! tyler - Original Message - From: "Stewart Gateley" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]>; "DL Neil" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 5:56 PM Subject: Re: "SET field=field+1" no longer works? > Try: > > UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND > password='myfakepassword'; > > > I am using id=$id"); ?> and it works fine. > > -- Stewart > > --- Tyler Longren <[EMAIL PROTECTED]> wrote: > > Well, here's the query that PHP is generating: > > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND > > password='myfakepassword' > > > > If I copy and paste that exactly into the mysql client, it's executed > > correctly. If I use phpMyAdmin to execute it, it IS NOT executed > > correctly > > (same as in my PHP code). I really don't think this is a problem > > with my > > coding since it worked with previous versions of mysql. Could PHP > > just be > > screwing up while sending the query to MySQL? > > > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get > > executed properly. It only works correctly when issuing the query > > from the > > mysql command line client. :) > > > > Tyler > > > > - Original Message - > > From: "DL Neil" <[EMAIL PROTECTED]> > > To: "Tyler Longren" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 26, 2002 8:52 AM > > Subject: Re: "SET field=field+1" no longer works? > > > > > > > Hi Tyler, > > > [back on-list so that others can offer their wisdom!] > > > > > > OK, so it's not a problem with the MySQL client, then it's likely > > the PHP. > > Most likely that the username and > > > password data values are strings and need to be properly contained > > with > > single- or double-quotation marks. > > > > > > If you need further assistance, first try some debug ECHOs on the > > three > > fields used in the query, and ECHO the > > > query itself immediately prior to the call to MySQL. (is the last > > how you > > posted (copy-pasted) the query into > > > the MySQL client, or did you type it into MySQL by hand?) > > > > > > If lights still don't go off, please post the PHP code snippet. > > > > > > Regards, > > > =dn > > > > > > > > > > I tried it in PHP first, and it doesn't work in that. But, when > > I use > > the > > > > mysql client, it works as expected. Any ideas? > > > > > > > > > > > Hello Tyler, > > > > > > > > > > Did someone pick up this question - haven't spotted a response > > on the > > > > list? > > > > > I haven't spotted any such mis-behavior under either Win2000 or > > WinNT. > > > > > > > > > > Are you entering the query at the command line or into some > > tool? > > > > > Have you tried another client? > > > > > > > > > > If it is still unresolved, send me (NOT the whole list) the > > actual > > query, > > > > and a short table with sample data, > > > > > and I'll try it on my two Win boxes here. > > > > > > > > > > Regards, > > > > > =dn > > > > > > > > > > > > > > > > I'm running MySQL on a Windows 2000 box. I was running > > 3.23.47 > > until > > > > > > 3.23.49 was released. After upgrading to 3.23.49, queries > > like this > > > > don't > > > > > > work: > > > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE > > username='blah' > > > > AND > > > > > > password='blah'; > > > > > > > > > > > > Normally, that would increment the value in board_posts by 1, > >
Re: "SET field=field+1" no longer works?
Try: UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND password='myfakepassword'; I am using and it works fine. -- Stewart --- Tyler Longren <[EMAIL PROTECTED]> wrote: > Well, here's the query that PHP is generating: > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND > password='myfakepassword' > > If I copy and paste that exactly into the mysql client, it's executed > correctly. If I use phpMyAdmin to execute it, it IS NOT executed > correctly > (same as in my PHP code). I really don't think this is a problem > with my > coding since it worked with previous versions of mysql. Could PHP > just be > screwing up while sending the query to MySQL? > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get > executed properly. It only works correctly when issuing the query > from the > mysql command line client. :) > > Tyler > > - Original Message - > From: "DL Neil" <[EMAIL PROTECTED]> > To: "Tyler Longren" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, February 26, 2002 8:52 AM > Subject: Re: "SET field=field+1" no longer works? > > > > Hi Tyler, > > [back on-list so that others can offer their wisdom!] > > > > OK, so it's not a problem with the MySQL client, then it's likely > the PHP. > Most likely that the username and > > password data values are strings and need to be properly contained > with > single- or double-quotation marks. > > > > If you need further assistance, first try some debug ECHOs on the > three > fields used in the query, and ECHO the > > query itself immediately prior to the call to MySQL. (is the last > how you > posted (copy-pasted) the query into > > the MySQL client, or did you type it into MySQL by hand?) > > > > If lights still don't go off, please post the PHP code snippet. > > > > Regards, > > =dn > > > > > > > I tried it in PHP first, and it doesn't work in that. But, when > I use > the > > > mysql client, it works as expected. Any ideas? > > > > > > > > Hello Tyler, > > > > > > > > Did someone pick up this question - haven't spotted a response > on the > > > list? > > > > I haven't spotted any such mis-behavior under either Win2000 or > WinNT. > > > > > > > > Are you entering the query at the command line or into some > tool? > > > > Have you tried another client? > > > > > > > > If it is still unresolved, send me (NOT the whole list) the > actual > query, > > > and a short table with sample data, > > > > and I'll try it on my two Win boxes here. > > > > > > > > Regards, > > > > =dn > > > > > > > > > > > > > I'm running MySQL on a Windows 2000 box. I was running > 3.23.47 > until > > > > > 3.23.49 was released. After upgrading to 3.23.49, queries > like this > > > don't > > > > > work: > > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE > username='blah' > > > AND > > > > > password='blah'; > > > > > > > > > > Normally, that would increment the value in board_posts by 1, > this > no > > > longer > > > > > happens. Is there a different way I should do this now? > > > > > > > > > > Thanks, > > > > > Tyler > > > > > > > > > > > > > > > > > - > > > > > Before posting, please check: > > > > >http://www.mysql.com/manual.php (the manual) > > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archi
Re: "SET field=field+1" no longer works?
Nope, privs are the same. Tyler - Original Message - From: "Daniel Rosher" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]>; "DL Neil" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 5:19 PM Subject: RE: "SET field=field+1" no longer works? > Have privileges changed? > > Dan > > > -Original Message- > > From: Tyler Longren [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, 27 February 2002 11:55 a.m. > > To: DL Neil > > Cc: MySQL List > > Subject: Re: "SET field=field+1" no longer works? > > > > > > Well, here's the query that PHP is generating: > > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND > > password='myfakepassword' > > > > If I copy and paste that exactly into the mysql client, it's executed > > correctly. If I use phpMyAdmin to execute it, it IS NOT executed > > correctly > > (same as in my PHP code). I really don't think this is a problem with my > > coding since it worked with previous versions of mysql. Could PHP just be > > screwing up while sending the query to MySQL? > > > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get > > executed properly. It only works correctly when issuing the > > query from the > > mysql command line client. :) > > > > Tyler > > > > - Original Message - > > From: "DL Neil" <[EMAIL PROTECTED]> > > To: "Tyler Longren" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 26, 2002 8:52 AM > > Subject: Re: "SET field=field+1" no longer works? > > > > > > > Hi Tyler, > > > [back on-list so that others can offer their wisdom!] > > > > > > OK, so it's not a problem with the MySQL client, then it's > > likely the PHP. > > Most likely that the username and > > > password data values are strings and need to be properly contained with > > single- or double-quotation marks. > > > > > > If you need further assistance, first try some debug ECHOs on the three > > fields used in the query, and ECHO the > > > query itself immediately prior to the call to MySQL. (is the > > last how you > > posted (copy-pasted) the query into > > > the MySQL client, or did you type it into MySQL by hand?) > > > > > > If lights still don't go off, please post the PHP code snippet. > > > > > > Regards, > > > =dn > > > > > > > > > > I tried it in PHP first, and it doesn't work in that. But, when I use > > the > > > > mysql client, it works as expected. Any ideas? > > > > > > > > > > > Hello Tyler, > > > > > > > > > > Did someone pick up this question - haven't spotted a > > response on the > > > > list? > > > > > I haven't spotted any such mis-behavior under either > > Win2000 or WinNT. > > > > > > > > > > Are you entering the query at the command line or into some tool? > > > > > Have you tried another client? > > > > > > > > > > If it is still unresolved, send me (NOT the whole list) the actual > > query, > > > > and a short table with sample data, > > > > > and I'll try it on my two Win boxes here. > > > > > > > > > > Regards, > > > > > =dn > > > > > > > > > > > > > > > > I'm running MySQL on a Windows 2000 box. I was running 3.23.47 > > until > > > > > > 3.23.49 was released. After upgrading to 3.23.49, > > queries like this > > > > don't > > > > > > work: > > > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE > > username='blah' > > > > AND > > > > > > password='blah'; > > > > > > > > > > > > Normally, that would increment the value in board_posts by 1, this > > no > > > > longer > > > > > > happens. Is there a different way I should do this now? > > > > > > > > > > > > Thanks, > > > > > > Tyler > > > > > > > > > > > > > > > > > > > > -
RE: "SET field=field+1" no longer works?
Have privileges changed? Dan > -Original Message- > From: Tyler Longren [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 27 February 2002 11:55 a.m. > To: DL Neil > Cc: MySQL List > Subject: Re: "SET field=field+1" no longer works? > > > Well, here's the query that PHP is generating: > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND > password='myfakepassword' > > If I copy and paste that exactly into the mysql client, it's executed > correctly. If I use phpMyAdmin to execute it, it IS NOT executed > correctly > (same as in my PHP code). I really don't think this is a problem with my > coding since it worked with previous versions of mysql. Could PHP just be > screwing up while sending the query to MySQL? > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get > executed properly. It only works correctly when issuing the > query from the > mysql command line client. :) > > Tyler > > - Original Message - > From: "DL Neil" <[EMAIL PROTECTED]> > To: "Tyler Longren" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, February 26, 2002 8:52 AM > Subject: Re: "SET field=field+1" no longer works? > > > > Hi Tyler, > > [back on-list so that others can offer their wisdom!] > > > > OK, so it's not a problem with the MySQL client, then it's > likely the PHP. > Most likely that the username and > > password data values are strings and need to be properly contained with > single- or double-quotation marks. > > > > If you need further assistance, first try some debug ECHOs on the three > fields used in the query, and ECHO the > > query itself immediately prior to the call to MySQL. (is the > last how you > posted (copy-pasted) the query into > > the MySQL client, or did you type it into MySQL by hand?) > > > > If lights still don't go off, please post the PHP code snippet. > > > > Regards, > > =dn > > > > > > > I tried it in PHP first, and it doesn't work in that. But, when I use > the > > > mysql client, it works as expected. Any ideas? > > > > > > > > Hello Tyler, > > > > > > > > Did someone pick up this question - haven't spotted a > response on the > > > list? > > > > I haven't spotted any such mis-behavior under either > Win2000 or WinNT. > > > > > > > > Are you entering the query at the command line or into some tool? > > > > Have you tried another client? > > > > > > > > If it is still unresolved, send me (NOT the whole list) the actual > query, > > > and a short table with sample data, > > > > and I'll try it on my two Win boxes here. > > > > > > > > Regards, > > > > =dn > > > > > > > > > > > > > I'm running MySQL on a Windows 2000 box. I was running 3.23.47 > until > > > > > 3.23.49 was released. After upgrading to 3.23.49, > queries like this > > > don't > > > > > work: > > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE > username='blah' > > > AND > > > > > password='blah'; > > > > > > > > > > Normally, that would increment the value in board_posts by 1, this > no > > > longer > > > > > happens. Is there a different way I should do this now? > > > > > > > > > > Thanks, > > > > > Tyler > > > > > > > > > > > > > > > > - > > > > > Before posting, please check: > > > > >http://www.mysql.com/manual.php (the manual) > > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archive) >
Re: "SET field=field+1" no longer works?
Well, here's the query that PHP is generating: UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND password='myfakepassword' If I copy and paste that exactly into the mysql client, it's executed correctly. If I use phpMyAdmin to execute it, it IS NOT executed correctly (same as in my PHP code). I really don't think this is a problem with my coding since it worked with previous versions of mysql. Could PHP just be screwing up while sending the query to MySQL? Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get executed properly. It only works correctly when issuing the query from the mysql command line client. :) Tyler - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 8:52 AM Subject: Re: "SET field=field+1" no longer works? > Hi Tyler, > [back on-list so that others can offer their wisdom!] > > OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely that the username and > password data values are strings and need to be properly contained with single- or double-quotation marks. > > If you need further assistance, first try some debug ECHOs on the three fields used in the query, and ECHO the > query itself immediately prior to the call to MySQL. (is the last how you posted (copy-pasted) the query into > the MySQL client, or did you type it into MySQL by hand?) > > If lights still don't go off, please post the PHP code snippet. > > Regards, > =dn > > > > I tried it in PHP first, and it doesn't work in that. But, when I use the > > mysql client, it works as expected. Any ideas? > > > > > Hello Tyler, > > > > > > Did someone pick up this question - haven't spotted a response on the > > list? > > > I haven't spotted any such mis-behavior under either Win2000 or WinNT. > > > > > > Are you entering the query at the command line or into some tool? > > > Have you tried another client? > > > > > > If it is still unresolved, send me (NOT the whole list) the actual query, > > and a short table with sample data, > > > and I'll try it on my two Win boxes here. > > > > > > Regards, > > > =dn > > > > > > > > > > I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until > > > > 3.23.49 was released. After upgrading to 3.23.49, queries like this > > don't > > > > work: > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' > > AND > > > > password='blah'; > > > > > > > > Normally, that would increment the value in board_posts by 1, this no > > longer > > > > happens. Is there a different way I should do this now? > > > > > > > > Thanks, > > > > Tyler > > > > > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "SET field=field+1" no longer works?
Hi Tyler, [back on-list so that others can offer their wisdom!] OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely that the username and password data values are strings and need to be properly contained with single- or double-quotation marks. If you need further assistance, first try some debug ECHOs on the three fields used in the query, and ECHO the query itself immediately prior to the call to MySQL. (is the last how you posted (copy-pasted) the query into the MySQL client, or did you type it into MySQL by hand?) If lights still don't go off, please post the PHP code snippet. Regards, =dn > I tried it in PHP first, and it doesn't work in that. But, when I use the > mysql client, it works as expected. Any ideas? > > Hello Tyler, > > > > Did someone pick up this question - haven't spotted a response on the > list? > > I haven't spotted any such mis-behavior under either Win2000 or WinNT. > > > > Are you entering the query at the command line or into some tool? > > Have you tried another client? > > > > If it is still unresolved, send me (NOT the whole list) the actual query, > and a short table with sample data, > > and I'll try it on my two Win boxes here. > > > > Regards, > > =dn > > > > > > > I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until > > > 3.23.49 was released. After upgrading to 3.23.49, queries like this > don't > > > work: > > > UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' > AND > > > password='blah'; > > > > > > Normally, that would increment the value in board_posts by 1, this no > longer > > > happens. Is there a different way I should do this now? > > > > > > Thanks, > > > Tyler > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "SET field=field+1" no longer works?
Hello Tyler, Did someone pick up this question - haven't spotted a response on the list? I haven't spotted any such mis-behavior under either Win2000 or WinNT. Are you entering the query at the command line or into some tool? Have you tried another client? If it is still unresolved, send me (NOT the whole list) the actual query, and a short table with sample data, and I'll try it on my two Win boxes here. Regards, =dn > I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until > 3.23.49 was released. After upgrading to 3.23.49, queries like this don't > work: > UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND > password='blah'; > > Normally, that would increment the value in board_posts by 1, this no longer > happens. Is there a different way I should do this now? > > Thanks, > Tyler > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php