/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 vote293 views1 answer
Postgresql create table many-to-many
SQL
3 votes263 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote276 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
2 votes269 views1 answer
Sql create database
SQL
3 votes284 views1 answer
Laravel database Using Named Bindings
SQL
0 vote267 views1 answer
Mysql shell set time_zone
SQL
1 vote264 views2 answers
End mysql command
SQL
7 votes280 views2 answers
Show size database mysql
SQL
1 vote294 views1 answer
Sql server delete top 1000
SQL
0 vote224 views1 answer
Check if has alpha characters sql
SQL