Mysql on delete set null

Update foreign key value in mysql

SET foreign_key_checks = 0;
UPDATE languages SET id='xyz' WHERE id='abc';
UPDATE categories_languages SET language_id='xyz' WHERE language_id='abc';
SET foreign_key_checks = 1;

Source: stackoverflow.com

How to delete the rows with null values in mysql

DELETE FROM user WHERE username IS NULL;

To Delete the Rows with the Null values if present in any specific Columns.

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: techonthenet.com

Similar codes

0 vote198 views2 answers
Execute stored procedure without db set
SQL
0 vote147 views1 answer
Oracle last user logon
SQL
0 vote215 views1 answer
Create-table-with-index-organization
SQL
1 vote200 views1 answer
Postgres delete from where date is greater than specific date
SQL
-1 vote188 views3 answers
Update mongodb version ubuntu
SQL
0 vote209 views1 answer
To_date sql
SQL
0 vote182 views1 answer
Mysql start of today
SQL
2 votes201 views3 answers
Oracle show column of table
SQL
0 vote159 views1 answer
Mysqli or pdo
SQL
4 votes203 views1 answer
Create db table
SQL