mysql delete function code example
Example 1: mysql delete
DELETE FROM table_name
WHERE some_column = some_value
Example 2: mysql on delete
[CONSTRAINT [symbol]] FOREIGN KEY
[index_name] (col_name, ...)
REFERENCES tbl_name (col_name,...)
[ON DELETE reference_option]
[ON UPDATE reference_option]
reference_option:
RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT