/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

3 votes95 views2 answers
Postgres show table schema
SQL
0 vote96 views1 answer
Oracle sql number to varchar2
SQL
10 votes91 views1 answer
Oracle dba_dependencies
SQL
0 vote89 views1 answer
Sql remove decimal places
SQL
1 vote84 views1 answer
Oracle finding duplicate records
SQL
0 vote87 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote98 views1 answer
Increase existing date in sql
SQL
49 votes156 views6 answers
Alter table add column
SQL
0 vote100 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote103 views1 answer
Mysql current running queries
SQL