ALTER TABLE tblname ADD UNIQUE (column1, column2);
The index will automatically be used if you use it in your WHERE clause in
that order. If you want to do fulltext searching on those columns, repeat
the query with FULLTEXT in place of UNIQUE.
> Hello,
>
> I'm trying to create a table with colum
Hello,
I'm trying to create a table with columns A, B, C, D such that values in
columns A and B are not unique but if you consider them as a paired tuple,
then for every row, is
unique. Furthermore, I'd like to create a index to use for searching
through the database using this unique paired tup
