/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

10 votes256 views1 answer
Oracle all_dependencies
SQL
0 vote189 views1 answer
Turnicate in mysql
SQL
9 votes186 views4 answers
Add primary key to existing table sql
SQL
0 vote178 views1 answer
Postgresql create table many-to-many
SQL
0 vote195 views1 answer
GROUP BY postgres
SQL
2 votes193 views2 answers
Laravel query builder toSql
SQL
0 vote176 views1 answer
Psql select * from table
SQL
0 vote191 views1 answer
Postgresql copy backup table
SQL
0 vote189 views1 answer
Heidisql check how much space a row
SQL
0 vote188 views1 answer
Mysql create index lost connection
SQL