https://www.webmaster-forums.net/crss/node/1013988 en https://www.webmaster-forums.net/web-database-development/unique-fields-mysql-database#comment-1080910 <p>Yeah, it's just like assigning a primary key, must have missed it the first time though.</p> Wed, 11 Apr 2001 14:07:59 +0000 PDavis comment 1080910 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/unique-fields-mysql-database#comment-1080897 <p>I *think* this will do it:<br /> ALTER table_name ADD UNIQUE field_name</p> <p>You can read about the mySQL ALTER TABLE syntax <a href="http://www.mysql.com/doc/A/L/ALTER_TABLE.html" class="bb-url">here</a></p> Wed, 11 Apr 2001 06:48:13 +0000 Mark Hensler comment 1080897 at https://www.webmaster-forums.net