I have a table BLE_PINS
with columns TN, MAC, PIN, and Date. MAC is the primary key. When entering
INSERT INTO `BLE_PINS` (`MAC`, `PIN`) VALUES ('SEEP413E68','99933');
I get the error
#1062 – Duplicate entry ‘SEEP41’ for key ‘PRIMARY’`.
It seems to be matching only the first 6 characters. Is there a way to change that?
Table definition:
CREATE TABLE BLE_PINS (
TN varchar(16) DEFAULT NULL,
MAC varchar(100) NOT NULL,
PIN varchar(6) NOT NULL,
Date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (MAC(6))
) ENGINE=InnoDB DEFAULT CHARSET=latin1
You need to sign in to view this answers