/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 votes171 views4 answers
Join multiple tables in sql
SQL
0 vote194 views1 answer
Reindexing all tables sql server
SQL
1 vote156 views1 answer
Mysql date diff in seconds
SQL
0 vote203 views1 answer
Start stop mysql linux
SQL
21 votes178 views3 answers
Sql server search column name in all tables
SQL
0 vote158 views1 answer
Sqlite3_open_v2
SQL
0 vote170 views1 answer
Connect to ssms with python
SQL
0 vote185 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote118 views1 answer
Into sql
SQL
1 vote150 views2 answers
Mysql current user
SQL