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]
