Re: CREATE TABLE issue?

2002-12-20 Thread Paul DuBois 
At 17:13 + 12/20/02, Jeff Snoxell wrote:

Hi again :)

I found the following mysql stuff in the MySQL manual in a section 
explaining how to do relationships.

CREATE TABLE persons (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE shirts (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
style ENUM('t-shirt', 'polo', 'dress') NOT NULL,
color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL,
owner SMALLINT UNSIGNED NOT NULL REFERENCES persons,
PRIMARY KEY (id)
);

What's the point of the REFERENCES persons bit at the end of the 
definition of table Shirts? It doesn't seem to do anything.

Right, you can leave it out.


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: CREATE TABLE issue?

2002-12-20 Thread Adolfo Bello 
Missing TYPE=INNODB in create table statement.

MySQL parses references for type MyISAM but doesn't use them.

Adolfo

 -Original Message-
 From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] 
 Sent: Friday, December 20, 2002 1:14 PM
 To: [EMAIL PROTECTED]
 Subject: CREATE TABLE issue?
 
 
 Hi again :)
 
 I found the following mysql stuff in the MySQL manual in a section 
 explaining how to do relationships.
 
 CREATE TABLE persons (
  id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  name CHAR(60) NOT NULL,
  PRIMARY KEY (id)
 );
 
 CREATE TABLE shirts (
  id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  style ENUM('t-shirt', 'polo', 'dress') NOT NULL,
  color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL,
  owner SMALLINT UNSIGNED NOT NULL REFERENCES persons,
  PRIMARY KEY (id)
 );
 
 What's the point of the REFERENCES persons bit at the end of the 
 definition of table Shirts? It doesn't seem to do anything.
 
 Jeff
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php