Incorrect integer value: "$ NewCity" in column "newcity" at line 1

//The field types do not match. The field in the table is set to an integer, but you gave a string. Modify fields or process submitted values as appropriate.

The data in column "HirePayDate" in line 1 is too long.

(1) It may be that the length of the' HirePayDate' field is set too small, and the submitted value exceeds the length.

(2) It is also possible that the field codes are inconsistent.

Solve:

(1) Increase the field length. Remember that if it is gbk/gb23 12, Chinese takes up two bytes. When setting the field length in mysql, pay attention to increase it.

(2) Set the database code to make the inserted data code consistent.

The field "TypeOK" has no default value.

No value is assigned to this field, but it is set to not null.

Solution: If the value of this field will not be submitted every time, change the field setting and allow it to be empty, or set the default value.

The field "TypeOK" has no default value.

============

As said upstairs, it is recommended that echo come out with your sql and query the analyzer to execute it. See what's wrong.