mysql中如何替代oracle中的EMPTY_BLOB()
- Java code
String sql = "insert into SSC_InsuranceCardMovement(oid,managedOrgId,cardFile) values(?,?,EMPTY_BLOB()) ";PreparedStatement ps = conn.prepareStatement(sql);
执行会报 FUNCTION EMPTY_BLOB does not exist
mysql可有替代方法?还请各位帮帮忙!
[解决办法]
String sql = "insert into SSC_InsuranceCardMovement(oid,managedOrgId,cardFile) values(?,?,NULL) ";