Foreign Key and default action/RESTRICT behaviour?

Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}] [ON UPDATE {

foreign keys across databases?

This might be a stupid question, but is it possible to have a foreign key reference to a table.column in another database? E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) Probably not, but are there any other ways to enforce such relations? Best regards Tor Rune Skoglund [EMAIL

Re: Mysql 4.0

Hi, glad to hear that it is not only me... I got the same error on Pentium 200MMX, even when compiling the source. I found that configure prepared gcc for Pentium Pro, so the quick and dirty fix was to hardcode Pentium into the configure script. This must be a bug... Tor Rune Skoglund, Gyldenlø