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 Durana | 24 May |