How to set up cascading deletes in MySQL workbench?

mysql sql cascading-deletes
MadSeb picture MadSeb · Feb 10, 2012 · Viewed 19.1k times · Source

In MySQL Workbench, how do you set up a cascading delete on a relationship?

I clicked the relationship line and clicked on properties but I do not see any mention of a cascading delete option.

Answer

J Cooper picture J Cooper · Feb 10, 2012

Right Click On Table -> Alter Table -> Foreign Keys Tab

Look at the upper-right corner "Foreign Key Options", there are two drop down boxes, one is to specify the delete action: "On Delete"

enter image description here

Related questions

How to delete automatically all reference rows if parent row get deleted in mysql?

I have a database which contains around 50 tables. Suppose I have a table named parent with id primary key and 24 approx child tables with reference to this parent table. I haven't used on delete cascade. I have already searched about …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More