When creating a table in the commandlineclient of mysql

The following is my problem. The final solution is as follows: add a "something like single quotes" to the field of the int number. Note that it is not single quotes, an error will still be reported if you use single quotes. In addition, fields of the float type also have such a field, and such a field of the float number must also be enclosed in single quotes. In particular, the float field.

The following is my problem. The final solution is as follows: add a "something like single quotes" to the field of the int number. Note that it is not single quotes, an error will still be reported if you use single quotes. In addition, fields of the float type also have such a field, and such a field of the float number must also be enclosed in single quotes. In particular, the float field.

The following is my problem. The final solution is as follows: add a "something like single quotes" to the int + number field ",

Note that it is not a single quotation mark and an error will still be reported if it is a single quotation mark.

In addition, fields of the float type also have such a field, and fields of the float + number must also contain such a field as single quotes.

In particular, float is a mysql bug. It is not allowed only when float4 is used.

Of course, when creating a table in the command line today, we also found that the Varchar type field must specify the length of the string: