On 6 Dec 2001 [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > * A PRIMARY KEY can be a multiple-column index. However, you cannot > create a multiple-column index using the PRIMARY KEY key attibute in a > column specification. Doing so will mark only that single column as > primary. You must use the PRIMARY KEY(index_col_name, ...) syntax. > > > On Thu, 6 Dec 2001, sherzodR wrote: > > > > > As far as I know, you can't do tht. What you could do instead is > > have one Primary Key col and make another one UNIQUE. > > > > I did that several times, and it does work! > > > > > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php