Mysql Add NULL Value in Field: [duplicate]

Question

I am trying to insert a record with one field as NULL but is return an ERROR:Column 'paid' cannot be null

NOTE: In Database table column paid is of type integer.

CODE

$sql="INSERT INTO `fees_receipt_temp_table`(`id`, `voucher_no`, `std_id`, `full_name`, `payable_fee`,paid) VALUES ('','$voucher_no','$std_id','$name','$payable',NULL)";

It isn't the dataype. You need to check if the column 'paid' allows NULL. Share your table schema if possible — Krishnakumar
– Krishnakumar, Commented Feb 15, 2017 at 9:19
check your database structure. you probably set the column 'paid' to NOT NULL. remove the constraint — Rotimi
– Rotimi, Commented Feb 15, 2017 at 9:19

Fallen · Accepted Answer · 2017-02-15 09:20:44Z

3

It's in your database table settings. If the column is set to be "NOT NULL", clear that constraint.

answered Feb 15, 2017 at 9:20

Fallen

4,5833 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sooraj Abbasi Over a year ago

Works for me thanks,

S.Visser · Accepted Answer · 2017-02-15 09:32:14Z

1

The database column is set on NOT NULL. Because of this the column does not accept NULL values.

If you wanna allow NULL as an option, you can alter it to run the following query.

ALTER TABLE fees_receipt_temp_table
ALTER COLUMN paid INT IS NULL

edited Feb 15, 2017 at 9:32

answered Feb 15, 2017 at 9:24

S.Visser

4,7751 gold badge25 silver badges48 bronze badges

Collectives™ on Stack Overflow

Mysql Add NULL Value in Field: [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related