List:General Discussion« Previous MessageNext Message »
From:Cristina Durana Date:May 24 1999 2:33pm
Subject:How to relational two tables in mysql?
View as plain text  
Hi all!!!!!!
I need to know how to make a relationship between two tables in mysql, where
the first table have the strutured for the books(registers) and the second
table have data from people that will receive information about the
register(s) that contains information about the subject choosen.

The tables are:

1) 
 +--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| nregister     | int(11)      |      | PRI | 0       |       |
| dsautor      | varchar(250) | YES  |     | NULL    |       |
| dstitle     | varchar(250) |      | MUL |         |       |
| dssubject     | varchar(250) |      | MUL |         |       |
| dspublicacion | varchar(250) | YES  |     | NULL    |       |
| dscolecion    | varchar(250) | YES  |     | NULL    |       |
| dsisbn       | varchar(50)  | YES  |     | NULL    |       |
+--------------+--------------+------+-----+---------+-------+

2)
 +--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| dsname     | int(11)      |      | PRI | 0       |       |
| dslastname     | int(11)      |      | PRI | 0       |       |
| dsaddress     | int(11)      |      | PRI | 0       |       |
| dsemail     | int(11)      |      | PRI | 0       |       |
+--------------+--------------+------+-----+---------+-------+

Thanks for your help.
SYS
Cristina


Thread
How to relational two tables in mysql?Cristina Durana24 May