Incorrect integer value for a column

Question

When I submit null in center_id (not an auto increment column) in single quotes it give me the error incorrect integer value for column center_id and when I write only the variable like this

center_id = $center_id

it gives a mysql error. Please tell me what I am doing wrong with it or suggest something. Below is my query.

Insert into parent_details set center_id='$center_id',name='$name',pin='$pin'

Thanks in advance.

NULL is without quotes, also check whether your column has attribute not null in which case it wont accept NULL values. — AyB
– AyB, Commented Apr 21, 2014 at 5:02
If center_id is an int datatype, you don't need to put the value in quotes. — Barmar
– Barmar, Commented Apr 21, 2014 at 5:03
Could you share the actual php code that you're using and what you're trying to accomplish? — Ja͢ck
– Ja͢ck, Commented Apr 21, 2014 at 5:07
Center_id data type is int and allowed as null(default null) — Debuger
– Debuger, Commented Apr 21, 2014 at 5:09

Mureinik · Accepted Answer · 2014-04-21 05:10:17Z

2

Numbers and nulls should not be quoted, strings should. Additionally, your syntax for inserting is wrong:

INSERT INTO parent_details (center_id, name, pin) VALUES ($center_id, '$name', $pin)

answered Apr 21, 2014 at 5:10

Mureinik

316k54 gold badges401 silver badges405 bronze badges

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

1 Comment

Debuger Over a year ago

when i not quote it out it gives me the error you have error in your mysql syntax on line 1 near pin................

Ja͢ck · Accepted Answer · 2014-04-21 05:11:47Z

If you're using prepared statements you shouldn't have this problem in the first place:

$stmt = $db->prepare('Insert into parent_details set center_id=:center, name=:name, pin=:pin'); $stmt->execute([ ':center' => null, ':name' => 'foo', ':pin' => 'bar', ]);

AyB · Accepted Answer · 2014-04-21 05:14:09Z

field center_id data type is int but you may inserted string or special characters because of that is giving above error use below code try to insert integer to center_id column

insert into parent_details (center_id,name,pin) VALUES ($center_id, $name, $pin)

Collectives™ on Stack Overflow

Incorrect integer value for a column

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related