mysql add foreign key for delete cascade

This one adds a constraint to the orderdetails table such as if the order is deleted, its details get deleted too

ALTER TABLE pedidos_detalle add constraint foreign key(folio) references pedidos(folio) on delete cascade