Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql on delete set null


    FOREIGN KEY (child_col1, child_col2, ... child_col_n)
    REFERENCES parent_table (parent_col1, parent_col2, ... parent_col_n)
    ON DELETE SET NULL
    [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] 
Source by www.techonthenet.com #
 
PREVIOUS NEXT
Tagged: #mysql #delete #set #null
ADD COMMENT
Topic
Name
9+5 =