8 messages in com.mysql.lists.mysqlRE: relational tables
FromSent OnAttachments
Tom Jones12 Jan 2002 12:01 
Carsten H. Pedersen12 Jan 2002 15:35 
rc12 Jan 2002 15:52 
Tom Jones12 Jan 2002 16:37 
Neil Zanella12 Jan 2002 20:03 
DL Neil13 Jan 2002 03:33 
Javier Gonzalo Gloria Medina13 Jan 2002 14:59 
Roger Baklund13 Jan 2002 15:31 
Subject:RE: relational tables
From:Roger Baklund (roge@mobiliant.com)
Date:01/13/2002 03:31:36 PM
List:com.mysql.lists.mysql

* Javier Gonzalo Gloria Medina

How I crate this relational tables with mysql.

Using the CREATE TABLE statement:

<URL: http://www.mysql.com/doc/C/R/CREATE_TABLE.html >

where the two tables must be related by id ok

You combine the tables with the SELECT statement, you don't need to do anything special when you create the tables to tell mysql that the tables are related.

<URL: http://www.mysql.com/doc/S/E/SELECT.html >

-- Roger