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

12 votes100 views4 answers
SQL Where
SQL
5 votes120 views1 answer
Oracle sysdate - 1 month
SQL
3 votes110 views2 answers
Truncate table
SQL
1 vote111 views1 answer
Search for tables with name postgresql
SQL
1 vote66 views1 answer
Flask-sqlalchemy filter_by contains
SQL
1 vote108 views1 answer
Funzioni plsql
SQL
1 vote104 views1 answer
Setval pgsql
SQL
0 vote111 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
4 votes103 views1 answer
Select nls_date_format
SQL
0 vote106 views1 answer
Insert array into mysql column
SQL