4 messages in com.mysql.lists.win32Re: Auto Increment
FromSent OnAttachments
david groves12 Apr 2005 08:10 
Joseph Connolly12 Apr 2005 09:10 
Joseph Connolly12 Apr 2005 12:42 
jbon...@sola.com.au13 Apr 2005 17:38 
Subject:Re: Auto Increment
From:Joseph Connolly (joz@gmail.com)
Date:04/12/2005 12:42:21 PM
List:com.mysql.lists.win32

If you read the manual there is a tutorial on setting up table and defining data types. In ADDITION there is extenseive talk about keys and contraints. If you do not leanr how to use the information given to you, you will never learn. Perhaps you don't really want to use a Primary key in each scenario but would rather use UNIQUE. PErhaps you just need an INDEX on the columns. Maybe you need to have cascading updates and inserts in which case you will need a InnoDB table as opposed to a IMysam. If you read the manual all this information is there for you to read and then try to decide which strategy is best for you.

linkhomes2000 wrote:

Thank you for that very intuitive answer. Its so nice to meet such helpful people?

DG

----- Original Message ----- From: "Joseph Connolly" <joz@gmail.com> Cc: <win@lists.mysql.com> Sent: Tuesday, April 12, 2005 5:10 PM Subject: Re: Auto Increment

Please for the love of god, read the manual or google it

david groves wrote:

Hello,

This is a silly question, at least for those of you who know about MySql.

I

am building a db for my site, and to, get to nf3 have created a table for each room in a house. The question is this.

1. Can I have more than one PK in some tables, if so 2. When someone makes an entry into those different table , if the PK is

set

to auto increments will it be the same number in each table. IE table

room1,

room2, room3 these are three different table. Someone makes the first

entry,

would id Pk = 0 in all three tables?

Explained it as well as I can do?

Kind Regards

DG

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:

http://lists.mysql.com/win32?unsub=link@btconnect.com