Have you tried looking in the manual? This information should all be there somewhere. The URL is http://dev.mysql.com/doc/mysql/en/index.html.
According to relational theory, there can only be one PRIMARY KEY in any table, although it may contain multiple columns. I *think* you can have as many UNIQUE columns as you want but you should verify that in the manual. I *suspect* that MySQL allows only a single AUTO_INCREMENT column on each table. You should verify anything I've said with the manual to be sure. Rhino ----- Original Message ----- From: "Mulley, Nikhil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 16, 2004 10:11 AM Subject: How many UNIQUE Columns per table Hi all, I have a query , Please can someone just tell me the details of restrictions on how many maximum no of UNIQUE Columns can be there per table and how many maximum PRIMARY KEY Columns,HOW many maximumum AUTO_INCREMENT Columns can be there per table -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
