The create table ss (
S1 int the default 0 not null,
S2 varchar (100) the default 'not null,
Primary key (s1)
)

As a table, the current record, when importing data in the database of pb panel, tip:
SQLSTATE=S1000
[MySQL] [ODBC 8.0 (a) Driver] [mysqld 5.6.48 - log] Column 's2' always be null

No changes made to the database.

INSERT INTO ss (s1, s2) VALUES (?,?,?,?,? ,? )



If the database panel using the INSERT statement can be inserted into the normal, but most of the time derivative according to the panel directly Import from database, and then directly submit,

Would build table statements, or ODBC link parameters itself? PB does not support the MySQL database or say?

CodePudding user response:

PB is 12.5 version of the
MySQL is 5.7

CodePudding user response:

You insert a null value, of course, not

CodePudding user response:

This error message are written, s2 field cannot be null, you look at the insertion failure of s2 what assign the field value, simple and crude way is built inside the s2 of the not null to remove the line,