When we create a table field with Jeplus, we will be prompted with an error if our total length exceeds a certain limit, so keep in mind that the length of the type we create table fields must be within range when we use jeplus to create table fields.
First, the effect shows
Ii. preparatory work
1, Jeplus platform 5.0.0.2
2. mysql Database 5.7
Third, the realization step
1, Database Building table notes: Create the field of table fields must be within the specified range.
2 The corresponding database type is "text" when we use the Jeplus field type "string (4000)"
3 But in some scenarios we select the field type is "string (4000)" When space is not enough we can take another field type of "oversized text" or "huge text".
It corresponds to a database type of "Longtext".
The above two points are our considerations for creating a table.
Click to read the full
MySQL special qualification of tables for databases