Incorrect integer value when importing csv into a table via mysql workbench

Question

ERROR 1366: 1366: Incorrect integer value: '' for column 'subcategory_id' at row 1 SQL Statement:

INSERT INTO `db`.`shelf` (`shelf_id`, `model_code_name`, `customer_friendly_name`, `sku_code`, `description`, `unitmeasure_id`, `category_id`, `subcategory_id`, `colour`, `size`, `vendor_id`) 
VALUES ('919025', '', 'MS919025', 'NULL', '1', '3', '31', '', 'W1800*D900*H724MM', '10', '')

Alex · Accepted Answer · 2014-08-28 04:47:23Z

1

'' is not integer (between 31 and W1800)

answered Aug 28, 2014 at 4:47

Alex

11.6k7 gold badges39 silver badges52 bronze badges

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

Comments

Rahul Tripathi · Accepted Answer · 2014-08-28 04:47:12Z

1

You need to make the value of subcategory_id as integer value rather than ''

So the query should be like

INSERT INTO db.shelf (shelf_id, model_code_name, customer_friendly_name, sku_code, description, unitmeasure_id, category_id, subcategory_id, colour, size, vendor_id) 
VALUES ('919025', '', 'MS919025', 'NULL', '1', '3', '31', someintegervalue, 'W1800*D900*H724MM', '10', '')
                                                           ^^^^^^^^^^^^^^^

answered Aug 28, 2014 at 4:47

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Collectives™ on Stack Overflow

Incorrect integer value when importing csv into a table via mysql workbench

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related