mysql insert into怎么把空字符串转为NULL

$faceidResult = empty($faceidResult) ? "NULL" : "'$faceidResult'";
$sql = "INSERT INTO Cln_User (ID,Tel_Code, OtherImage, Ip_Country, Browser_Language, videoName, riskVideo,faceidResult, faceidStamp, riskStamp, Ip_City) 
        VALUES (NULL, '$Browser_Language', '$videoName', '$riskVideo', $faceidResult, '$faceidStamp', '$riskStamp', '$Ip_City');";

  

posted @ 2020-05-06 17:51  爱跑步的乌龟  阅读(2841)  评论(0编辑  收藏  举报