How to insert into database with setting the default values in phpmyadmin

Question

I have two phpmyadmin both are version 4.2.7 and PHPversion is PHP Version 5.4.24 one of phpmyadmin is allowing null values and another not accepting the null values

Phpmyadmin - 1

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

Phpmyadmin - 2

On the second table i didn't give the values for column3 its error like

I got error:

General error: 1364 Field 'column3' doesn't have a default value.

Even though i didn't set the null for phpmyadmin-1 but its working fine. How can i solve this ? Any suggestion ?

INSERT INTO table_name (column1,column2,...)
VALUES (value1,value2,...);

Solution

Check your code is like this

when you creating database you should apply this option as well.

And in your code assign Your value3=NULL.

Then add the above function as same.

INSERT INTO table_name (column1,column2,column3,...)
    VALUES (value1,value2,value3,...);

Comments

[Admin]

yes i got it but i dont want to define for all fields how can i fix for the whole db ? and read my question please

[Admin]

I have given the same for phpmyadmin -1 its working fine without assigning the null values

[Abdulla Nilam]

INSERT INTO table_name SET column1 = 'value1', column2= 'value2'. try this out

[Admin]

without nullable it was inserting in phpmadmin-1 got it ?

[Admin]

your answer not helped :(