| Mailing List | | Home | | MySQL General - General MySQL discussion | | MaxDB - Everything about MaxDB, formerly known as SAP DB | | MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP | | Java Help - Mostly related to the MySQL Connector/J driver | | ODBC - ODBC with the MySQL Connector/ODBC driver | | Perl - Perl support for MySQL with DBI and DBD::mysql | | MySQL++ - Programming with the C++ API to MySQL |
|
|
 | | | What exactly is happening with this table create? | What exactly is happening with this table create? 2004-03-15 - By vpendleton@(protected)
Back
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 <bhemphill@(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
> bhemphill@(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:victoria.reznichenko@(protected)]
> Sent: Monday, March 15, 2004 6:24 AM
> To: mysql@(protected)
> Subject: Re: Getting Identity after INSERT
> Alex Curvers <curvers@(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 @(protected) = @@(protected)
> >
> > after that you can use @(protected)
> >
> > 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
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@(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/mysql?unsub=bhemphill
@(protected)
> --
> MySQL General Mailing List
> For list archives:
http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=VPendleton
@(protected)
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=mysql
@(protected)
|
|
|