That is very odd behavior and shouldn't be happening. I ran a quick
test on my machine and MySQL does not exhibit that behavior. You may
try running and repair on your table. Perhaps something is out of
whack. What version of MySQL are you running?
On Apr 22, 2005, at 6:08 PM, ragan_davis@stripped wrote:
> Hello, all:
>
> In a MyISAM table, I have a column named "MAC", of type VARCHAR(17).
> This field is used to hold MAC addresses of computers' network
> interface cards. These MAC addresses are in the
> form "XX:XX:XX:XX:XX:XX", where X can be either a number or an
> uppercase letter. I can run "select * from table where
> MAC='00:04:FB:23:5A:44'" and the correct record is returned. However,
> performing "update table set port_index='123' where
> MAC='00:04:FB:23:5A:44'" does not work as I expected. It does update
> the correct record, but also updates all other records whose MAC field
> is empty. When I originally created this field, I used type VARCHAR
> (17), null, default value NULL. In troubleshooting this, I have since
> change the type to CHAR(17), not null, empty default value. Still
> have the same problem. Does anyone know what's going on here, and how
> I could correct this?
>
> Thanks!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
