https://www.cnblogs.com/sdfd101/p/5111851.html
There are two conventional methods
Solution 1: (enough)
In the database, set the default value for the error reporting field, integer: 0, string: null,
Find the corresponding table – design table – default selection box (set default value)
Solution 2:
MySQL installation directory – & gt; search open my.ini , find
sql mode = strict_ TRANS_ TABLES,NO_ AUTO_ CREATE_ USER,NO_ ENGINE_ SUBSTITUTION”
Amend to read
sql-mode=“NO_ AUTO_ CREATE_ USER,NO_ ENGINE_ SUBSTITUTION”
Then restart mysql
My own mistake is that the entity class doesn’t follow the hump rule. The appurl written by the entity class can be changed to appurl. I don’t pay attention to this very often
Read More:
- Error 1364 (HY000): field ‘SSL_ cipher’ doesn’t have a default value
- Mybatis error “field ‘ID’ doesn’t have a default value”
- Get the default value of the field
- In SQLite database, set the default value for the field as the current time
- PostgreSQL sets the default value of the field to the current year
- Use xx [‘xx ‘] = XX to set field value or does not support field: XXX
- MySQL：ERROR 1067 (42000): Invalid default value for ‘end_time’
- Table ‘sell.hibernate_sequence‘ doesn‘t exist
- mysql Table ‘performance_ schema.session_ Variables’ doesn’t exist solution
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- 1072 – Key column ‘xxx_id’ doesn’t exist in table
- urllib3 (1.26.4) or chardet (4.0.0) doesn‘t match a supported version!
- Django. DB. Utils. Programmingerror: (1146, “table * doesn’t exist”) causes and Solutions
- Solve the problem that the interface between C # WinForm program and Oracle doesn’t respond for a long time
- Unknown column ‘Password‘ in ‘field list‘
- Cause: java.sql.BatchUpdateException: Unknown column ‘xxx‘ in ‘field list‘
- Set the default time to the current value in MySQL
- MySQL error: column ‘ID’ in field list is ambiguous
- MySQL unknown column ‘in’ field list ‘solution
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’