XkKbmRXN

1SQL Code for INSERT while checking of multiple keys for duplicates
2CREATE TABLE IF NOT EXISTS `customer_list` (
3   `id` INT AUTO_INCREMENT,
4   `first_name` char(4) NOT NULL,
5   `last_name` varchar(80) NOT NULL,
6   `phone` varchar(50) NOT NULL,
7   `province` varchar(50) NOT NULL,
8   `country` varchar(30) NOT NULL,
9   `start_date` TIMESTAMP NOT NULL,
10   `end_date` TIMESTAMP NOT NULL,
11   PRIMARY KEY (id)
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
13	
14alter table customer_list add unique index(first_name, last_name, phone);