mysql - MYSQL 错误：ip 不能为空

Question

我有如下插入命令

   Insert into table1 (host, ip, domain ) 
    select hostname, (case when t1.ip is null then 'Not Defined' end) , domain from table1 t1, table2 t2 
    where t1.status = "Done"
    and t2.statusnew not regexp "True"
    limit 10 ;

得到错误：ip cannot be null

标签： mysqlnull