MySQL special qualification of tables for databases

When we create a table field with Jeplus, we will be prompted with an error if our total length exceeds a certain limit, so when we use jeplus When you create a table field, keep in mind that the length of the type that we create table fields must be within range.

One, effect display

II, preparing for 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 When the "string (4000)" space is not enough, we can take another type of field , "super-large text" or "huge text."

It corresponds to a database type of "Longtext".

The above two points are our considerations for creating a table.

Http://jestq.com/WEB/platform/platform.html

MySQL special qualification of tables for databases