/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

4 votes152 views2 answers
Float postgres
SQL
0 vote142 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote131 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote144 views1 answer
Postgres regex remove special characters
SQL
0 vote134 views1 answer
Transaction database with php
SQL
13 votes132 views5 answers
Select last row mysql
SQL
0 vote144 views1 answer
Sqlplus change user
SQL
0 vote194 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
10 votes142 views5 answers
Between keyword in sql
SQL
42 votes210 views6 answers
Sql query duplicate rows
SQL