connect fieldname of tabel A with record 'fieldname' of file B
This is a discussion on connect fieldname of tabel A with record 'fieldname' of file B within the MySQL forums, part of the Database Server Software category; --> I would like to connect a field (name=E_mod) of table A with a record in table B that has ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 11:30 AM
| ||||
| ||||
 connect fieldname of tabel A with record 'fieldname' of file B I would like to connect a field (name=E_mod) of table A with a record in table B that has in a varchar field "E_mod". How do I do that ? It's sort of like a JOIN, but on a different level...      |
|
02-28-2008, 11:30 AM
| |||
| |||
| Re: connect fieldname of tabel A with record 'fieldname' of file B On Tue, 11 Dec 2007 10:56:21 +0100, Osiris <et57@hotmail.com> wrote: > I would like to connect a field (name=E_mod) of table A with a record in > table B that has in a varchar field "E_mod". How do I do that ? > It's sort of like a JOIN, but on a different level... What do you mean exactly by 'connect'? Foreign keys perhaps? <http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html> -- Rik Wasmus |
|
02-28-2008, 11:30 AM
| ||||
| ||||
| Re: connect fieldname of tabel A with record 'fieldname' of file B On Tue, 11 Dec 2007 11:09:25 +0100, Rik Wasmus wrote: > On Tue, 11 Dec 2007 10:56:21 +0100, Osiris <et57@hotmail.com> wrote: > >> I would like to connect a field (name=E_mod) of table A with a record in >> table B that has in a varchar field "E_mod". How do I do that ? >> It's sort of like a JOIN, but on a different level... > > What do you mean exactly by 'connect'? Foreign keys perhaps? > <http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html> see my next post: "field features..." |
Linear Mode
