如果值为null，则跳过插入查询Mysql

Question

Hi i have a table with different fields and i make an insert query and i want to skip the insert query if a value is null in one of the fields. Example

Table
id    name    surname    kids
1     john      doe       2
2     mary      jones     3

and i want if the new insert has no value in the field kids to skip that entry. is there a possible way to check that?` the code i have is this

INSERT INTO `clients`.`kids` (`id`, `name`,`surname`,`kids`) VALUES (NULL,'".$data['name']."','".$data['surname']."','".$data['kids']."');";`

Answer 1

Just add a check -

if (!empty($data['kids'])) {
    // run the query
}