You did not state the tool you are using so I am not sure if the syntax is meant to be a constraint or an index. Since an Index was stated once for each column I am assuming the first UNIQUE is a constraint while the actual index is preceded by the INDEX keyword.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/15/04, 8:03:59 AM, Boyd "E." Hemphill <[EMAIL PROTECTED]> wrote regarding What exactly is happening with this table create?: > Using a tool to generate a data model I go the following statement: > Create table StateN ( > StateId Int NOT NULL AUTO_INCREMENT, > StateNm Char(50) NOT NULL DEFAULT '', > StateCd Char(7) NOT NULL DEFAULT '', > SortInt Int NOT NULL DEFAULT 0, > UNIQUE (StateId), > UNIQUE (StateCd), > Primary Key (StateId), > UNIQUE Index ak_State (StateCd) > ) TYPE = InnoDB > ROW_FORMAT = Default; > The last four statements seem to be redundant in that the > UNIQUE(StateId) is a proper subset of the Primary Key(StateId) statement > and is StateCd to its index. > My question is, what is happening in terms of the objects I am creating? > That is: Am I creating for indexes or two? Are they the pk and ak that > I want (last two statements) or is the server only creating the first > two? > Any insight here is greatly appreciated! > Best Regards, > Boyd E. Hemphill > [EMAIL PROTECTED] > Triand, Inc. > Life is not a journey to the grave arriving safely in a well preserved > body, but rather a skid in broadside, thoroughly used, totally worn, and > loudly proclaiming: "WOW! What a ride!" > -----Original Message----- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > Sent: Monday, March 15, 2004 6:24 AM > To: [EMAIL PROTECTED] > Subject: Re: Getting Identity after INSERT > Alex Curvers <[EMAIL PROTECTED]> wrote: > > > > Whats the preferred syntax to insert values in multiple (related) > tables > > I insert one record, then i need the ID of the inserted value to add > it > > the with the other inserts > > > > with MSSQL stored procs its > > > > INSERT INTO ..................................... > > SELECT @MyID = @@IDENTITY > > > > after that you can use @MyID > > > > So whats the preferred method with MySQL, is there a easy way to get > the > > Identity back from a just inserted record, or do i just have to do a > > select based on a value i did just insert ? > > > Use AUTO_INCREMENT column and LAST_INSERT_ID() function to retrieve most > recent auto_increment value: > http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html > http://www.mysql.com/doc/en/Information_functions.html > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
