In the last episode (Mar 27), Cal Evans said:
> Thanks for the clarification. I wasn't aware that MySQL (or any
> other SQL for that matter) stored records in a 'physical order'. I
> know in M$ SQL there is no such concept as records are constantly
> being reused as the contents are deleted. (a
you are using. (But hey, I've been wrong before.)
:)
Cal
http://www.calevans.com
-Original Message-
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:08 PM
To: Cal Evans
Cc: Duke; [EMAIL PROTECTED]
Subject: RE: keywords in CREATE TABLE?
I&
I'm not
> familiar with the distinction.
>
> Cal
> http://www.calevans.com
>
>
> -Original Message-
> From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 10:55 AM
> To: Cal Evans
> Cc: Duke; [EMAIL PROTECTED]
>
EMAIL PROTECTED]
Subject: RE: keywords in CREATE TABLE?
On Tue, 27 Mar 2001, Cal Evans wrote:
> Key = Creates an index
> Index = Same as above? (Not sure, the section of the manual I just glanced
> at seems to indicate that they are the same thing)
> PRIMARY KEY = Creates a primary key for
On Tue, 27 Mar 2001, Cal Evans wrote:
> Key = Creates an index
> Index = Same as above? (Not sure, the section of the manual I just glanced
> at seems to indicate that they are the same thing)
> PRIMARY KEY = Creates a primary key for the table. Each table should have a
> primary key and it shou
Key = Creates an index
Index = Same as above? (Not sure, the section of the manual I just glanced
at seems to indicate that they are the same thing)
PRIMARY KEY = Creates a primary key for the table. Each table should have a
primary key and it should be unique for that row in that table. (For mor
