如何在mysql中插入列值

Question

A db table consists of 3 columns. But I want to insert a value to one column and I want the other 2 to remain empty. Like database has three input column- roll, date, time, I want only to insert roll. My query:

insert into tableName(roll) values ('$_POST['roll'])

But I am getting the error message ( Field attn_time doesn't have a default value41 ). What would be the correct query?enter image description here

database table

Answer 1

You need to alter your database table by giving a default value to your attn_time column.

Example:

ALTER TABLE table_name MODIFY COLUMN column_name VARCHAR(255) NOT NULL DEFAULT '';