Mailing List Archive


Back to the month index Back to the list index
Ryan Scott (rscott@NetCreations.com)
Fri, 3 Jan 1997 22:17:24 +0000 

From: "Ryan Scott" <rscott@NetCreations.com>
Date: 	Fri, 3 Jan 1997 22:17:24 +0000
Subject: [mSQL] unique fields under msql2
Message-Id: <97Jan3.215558-0500_est.1603933-307+136@NetCreations.com>

I cannot for the life of me figure out how with msql2 I'm supposed to
specify that a field is the primary index, as in it should be unique.

With msql 1, I could just say

   username char(40) primary key,

but msql 2 did not like this.

How do I force msql to make username remain unique? I do not want
duplicate usernames...

I can't find this information anywhere. Anyone?

______________________________________________________________________
      Ryan Scott - rscott@netcreations.com - 718 522 1531
          - Reinventing Direct Marketing on the Net -
       NetCreations, Inc - http://www.netcreations.com
                - Targeted Voluntary Email -
PostMaster Direct Response - http://www.netcreations.com/postdirect/
             *be sure to quote me in your reply*
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!