Bug in SHOW PROCESSLIST?

2003-06-06 Thread Josh Smith
Hello, all. I have noticed over the last few days that when I do a SHOW PROCESSLIST on my MySQL server the host field always reports the same host IP address or name regardless of who is making the connection. Here is a run of the command on my machine: mysql> show processlist; +-+---

RE: I thought single UPDATE statements were atomic

2003-06-06 Thread Josh Smith
Mark, You could use the following: update t set num=num+1 order by num desc; Joshua -- [EMAIL PROTECTED] -Original Message- From: Mark Rages [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 9:17 PM To: O'K Web Design Cc: [EMAIL PROTECTED] Subject: Re: I thought single UPDATE sta