How would I define a foreign key in MySQL.

[Atia]

Defining foreign keys!
What I am trying to do is take information from two tables and put them into a new table.

For Example:

members table:
id int not null auto_increment primary key
fname.........
lname........
email varchar (150)

books table:
id int not null auto_increment primary key
title............

New table:
mebers_id
email
books_id

How would I define these if they are defined as above in there original tables.

Also can I take information from tables in one database and add to another database?

Atia

[r937]

"take information from two tables and put them into a new table"

you have to supply the data values for the new table yourself -- unless you're thinking of using a CROSS JOIN to populate it with allpossible combinations of members and books?

as far as foreign keys are concerned, if you want the database to enforce foreign keys, you need to declare these tables as InnoDB, and make sure they have indexes