/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

1 vote152 views1 answer
Sql count value greater than
SQL
0 vote148 views1 answer
Cast float mysql
SQL
0 vote168 views1 answer
Mysql config slave
SQL
2 votes241 views1 answer
Sql ends with string
SQL
0 vote154 views1 answer
Sql update subtract value
SQL
32 votes149 views6 answers
Sql count where
SQL
0 vote140 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote144 views2 answers
Sql use not in
SQL
2 votes182 views2 answers
How to check data type in sql server
SQL
0 vote142 views1 answer
Sql change date format
SQL