php - 数据库错误 "Field X doesn' t have a default value”是什么意思？

Question

下面是我为注册时事通讯创建的表格和表格。当我尝试在表单中输入一个新人时，我收到了这条消息。我该怎么做才能解决这个问题？

**Field 'ip_address' doesn't have a default value INSERT INTO member SET join_date = NOW() , first_name = 'John', last_name = 'D', email = 'jd@aol.com'

Field 'unsubscribe_date' doesn't have a default value INSERT INTO member SET join_date = NOW() , first_name = 'John', last_name = 'D', email = 'jd@aol.com'

Field 'unsubscribe_send_id' doesn't have a default value INSERT INTO member SET join_date = NOW() , first_name = 'John', last_name = 'D', email = 'jd@aol.com'**

这是我的表格:

    <table cellpadding="3" width="100%">
    <tbody>
        <tr>
            <td>Email <span class="required">*</span></td>
            <td><input type="text" class="text_input" name="email" value=""></td>
        </tr>
        <tr>
            <td>First Name <span class="required">*</span></td>
            <td><input type="text" class="text_input" name="first_name" value=""></td>
        </tr>
        <tr>
            <td>Last Name</td>
            <td><input type="text" class="text_input" name="last_name" value=""></td>
        </tr>
                    <tr>
            <td>
            Subscribed Communication
            </td>
            <td>
                <table>
                                                <tr>
                            <td><input type="checkbox" name="group_id[]" value="2" checked></td>
                            <td>RaceO'Clock Members</td>
                        </tr>
                                                                </table>
            </td>
        </tr>
        <tr>
            <td colspan="2" align="center">
                <input type="submit" name="submit" value="Subscribe!"> <br/>
                <em>* required fields</em>
            </td>
        </tr>
    </tbody>
    </table>


    </form>

这是我的 table :

CREATE TABLE IF NOT EXISTS `member` (
  `member_id` int(11) NOT NULL auto_increment,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `join_date` date NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `unsubscribe_date` date NOT NULL,
  `unsubscribe_send_id` int(11) NOT NULL,
  PRIMARY KEY  (`member_id`)
)  DEFAULT CHARSET=utf8;

Answer 1

插入语句中需要不带默认值的不为空的字段。

你有三个选择:

1. 定义一个默认值
2. 更改列定义以允许空值
3. 将该列添加到插入语句中