/SQL/How to delete the rows with null values in mysql

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 vote368 views1 answer
Sql column contains special character
SQL
1 vote357 views1 answer
Join to find results not in another table
SQL
0 vote372 views1 answer
Suhaib
SQL
-2 votes374 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote351 views1 answer
Codigo crear tablas sql server
SQL
9 votes361 views1 answer
Mysql check date range
SQL
11 votes380 views4 answers
Update row in mysql
SQL
0 vote389 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote356 views1 answer
Drop function
SQL
1 vote359 views1 answer
Mysql data from file
SQL