/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

12 votes244 views4 answers
Mysql get date difference in hours
SQL
7 votes271 views2 answers
How to create index mysql
SQL
0 vote233 views1 answer
Postgresql select fast check no rows
SQL
2 votes253 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote237 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote259 views1 answer
Use mysql in java program
SQL
5 votes247 views5 answers
Sqlite install python
SQL
1 vote264 views1 answer
Mysql login console
SQL
4 votes255 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
12 votes239 views4 answers
How to take database dump in postgresql
SQL