mysql foreign keys?

[Anon]

Hi,

I will just show my example database layout and then maybe someone can help me!

Table name = property {
Id smallint
Name varchar
Type smalling
Key (id)
}

table name = type {
id smallint
typeid smallint
typename varchar
key (id)
}

When I do a select on property I can get the "name" from property and "type" name from the table type?

For example I would have some data in property that looks like this:

Id = 1
Name = the sandpiper
Type = 3

And then in the table type I would have something like this:

Id = 1
Typeid = 3
Typename = condo/apartment

Basically when I do a "select * from property" I would like to see the typename not the type number? Know what I mean.. sorry I know this is complex I hope this example helps.

I hope to have many different typeid's and typename's. I just don't know what to select all the records without specifically naming them.

• Justin

[Anon]

hey,

could i do something like this "select property.name, type.typename from property inner join etc..." and then have something like a "where property.type = type.type"?

• Justin

[Anon]

yeah.. this works..

"select properties.id, protype.typename from properties, protype where properties.ptype = protype.id;"

i should have RTFM!

• Justin

[Anon]

BTW - this is a join question, foreign keys are different - they let you ENFORCE the relationship above...

Chris