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, [EMAIL PROTECTED] 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/[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
