首页 > 技术文章 > mysql insert into怎么把空字符串转为NULL

Essaycode 2020-05-06 17:51 原文

$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');";

  

推荐阅读