When MySQL is referenced using the Parameter-based code, the following message is always displayed: "Column 'column name' cannot be null ".

When using the Parameter-based code to reference MySQL, the following message is always displayed: "Column 'column name' cannot be null" to solve the problem of using the Parameter-based code in MySQL: solution 1: add an oldsyntax = true to the connection string. For example:

Server = 127.0.0.1; user id = root; password =; database = itemdb; oldsyntax = true

 

Solution 2: replace @? For example:

StringBuilder strSql = new StringBuilder (); strSql. append ("insert into test ("); strSql. append ("name)"); strSql. append ("values ("); strSql. append ("? Name) "); MySqlParameter [] parameters = {new MySqlParameter ("? Name ", MySqlDbType. VarChar, 45)}; parameters [0]. Value = model. name; DbHelperMySQL. ExecuteSql (strSql. ToString (), parameters );