[nycphp-talk] mySQL is kicking my butt Pt II
hans at nyphp.org
Mon Aug 18 11:09:02 EDT 2003
Phil Powell wrote:
> alter table fs_usermetadata add foreign key fs_user_category_id
> references fs_user_category(fs_user_category_id)
> on delete cascade
> Isn't this legitimate code to add a foreign key constraint to fs_user_category_id in table fs_usermetadata referencing fs_user_category.fs_user_category_id?
MySQL's default table handler, MyISAM, doesn't support foreign keys and so forth. So, unless this is an InnoDB DB, it won't work.
More information about the talk