/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 votes125 views3 answers
Start postgresql ubuntu
SQL
1 vote117 views1 answer
Sql trigger before delete
SQL
0 vote109 views1 answer
User defined variables in sql
SQL
0 vote116 views1 answer
T sql less than date
SQL
1 vote114 views1 answer
T-SQL Alter the column data type
SQL
1 vote125 views3 answers
How to pass password to mysql command line
SQL
0 vote126 views1 answer
Get date from timestamp in mysql
SQL
0 vote125 views2 answers
Sql regex vowel
SQL
0 vote120 views2 answers
Select index table oracle
SQL
0 vote108 views1 answer
Get records in sql according to month name and count
SQL