Create a New MYSQL Table With Unique


Unique MYSQL Table Creation

Create a Table where only there is no duplicate firstname / lastname combinations

CREATE TABLE members
(
lastname varchar(30) NOT NULL,
firstname varchar(30) NOT NULL,
UNIQUE (lastname, firstname)
);