mysql 外键

article表中有id

afa表中的article id

 

alter tabe afa add constraint fk_ada_id

foreign key fk_afa_id (articleid)

references article (id)

on delete cascade

on update cascade;