A statement like the following adds a unique constraint to an existing table that works with four of the table's columns (assume all table names and column names are valid). mysql> ALTER TABLE military_lookup -> ADD CONSTRAINT military_lookup_unl -> UNIQUE INDEX ( table_name O True O False column_name I , lookup_type , lookup_code);