mysql 表单内缺少值_PHPMyAdmin警报框-表单中缺少值-填写所有常用字段吗？

weixin_39754915

于 2021-01-19 05:11:17 发布

阅读量235

点赞数

文章标签： mysql 表单内缺少值

本文链接：https://blog.csdn.net/weixin_39754915/article/details/113209310

版权

在使用PHPMyAdmin保存表格时遇到问题，即使已输入所有常规信息，仍然出现'表单中缺少值！'的警告。尝试过更改数据类型、添加默认值、使用不同表引擎等方法，但问题未解决。解决方案可能是定义非空（NOT NULL）列时需要提供默认值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

For some reason while using PHPMyAdmin and attempting to save a table, even though I've entered all of the information I usually do I'm getting an alert box popping up with the content "Missing value in the form!".

Here's a screenshot of my PHPMyAdmin console (2 screens merged due to resolution):

What I've tried so far:

Changing the data types all to VARCHAR with a length of 255 (except for the deindeal_id column, which remained INT with a length of 12).

Encasing description in "`" (bacticks), thinking it may be a reserved word of some sort.

Adding a coalition.

Using different table engines (InnoDB, MyISAM (the one I wanted)).

I'm really stumped as to what could be causing this issue, so any answers would be greatly appreciated!

解决方案

Got the same error, probably a Bug.

What Lex said: "Maybe if you define a column NOT NULL (ie. don't check the box in the Null column, you have to define a default value? – Lex 20 hours ago"

Nope. Doesn't work either and wouldn't make much sense. If you don't define a default value, the server will either insert an empty string, or fail the query; depending on settings.