Rose,

Description of code:

ALTER TABLE table_name ADD UNIQUE(col_name):;

This command example comtains a syntax error, the ":" is extraneous.

The instruction was however exactly what I needed. I just wonder how to do this same "ALTER TABLE UNIQUE" by way of SQLyog; I could not find it in my client v5.15.

Ah well, Thanks!
Mike
View All Comments | View Tutorial