Why am I getting the error 'Column count doesn't match value count at row 1' when importing this .sql file?

Question

CREATE TABLE `produtos` ( 
        `sku` varchar(255) NOT NULL DEFAULT '', 
        `_store` varchar(255) NOT NULL DEFAULT '', 
        `_attribute_set` varchar(255) NOT NULL DEFAULT '', 
        `_type` varchar(255) NOT NULL DEFAULT '', 
        `_category` varchar(255) NOT NULL DEFAULT '', 
        `_product_websites` varchar(255) NOT NULL DEFAULT '', 
        `name` varchar(255) NOT NULL DEFAULT '', 
        `price` varchar(255) NOT NULL DEFAULT '', 
        `small_image` varchar(255) NOT NULL DEFAULT '', 
        `special_price` varchar(255) NOT NULL DEFAULT '', 
        `qty` varchar(255) NOT NULL DEFAULT '', 
        `min_qty` varchar(255) NOT NULL DEFAULT '', 
        `use_config_min_qty` varchar(255) NOT NULL DEFAULT '', 
        `is_qty_decimal` varchar(255) NOT NULL DEFAULT '', 
        `backorders` varchar(255) NOT NULL DEFAULT '', 
        `use_config_backorders` varchar(255) NOT NULL DEFAULT '', 
        `min_sale_qty` varchar(255) NOT NULL DEFAULT '', 
        `use_config_min_sale_qty` varchar(255) NOT NULL DEFAULT '', 
        `max_sale_qty` varchar(255) NOT NULL DEFAULT '', 
        `use_config_max_sale_qty` varchar(255) NOT NULL DEFAULT '', 
        `is_in_stock` varchar(255) NOT NULL DEFAULT '', 
        `notify_stock_qty` varchar(255) NOT NULL DEFAULT '', 
        `use_config_notify_stock_qty` varchar(255) NOT NULL DEFAULT '', 
        `manage_stock` varchar(255) NOT NULL DEFAULT '', 
        `use_config_manage_stock` varchar(255) NOT NULL DEFAULT '', 
        `use_config_qty_increments` varchar(255) NOT NULL DEFAULT '', 
        `qty_increments` varchar(255) NOT NULL DEFAULT '', 
        `use_config_enable_qty_increments` varchar(255) NOT NULL DEFAULT '', 
        `enable_qty_increments` varchar(255) NOT NULL DEFAULT '', 
        `_links_related_sku` varchar(255) NOT NULL DEFAULT '', 
        `_links_related_position` varchar(255) NOT NULL DEFAULT '', 
        `_links_crosssell_sku` varchar(255) NOT NULL DEFAULT '', 
        `_links_crosssell_position` varchar(255) NOT NULL DEFAULT '', 
        `_links_upsell_sku` varchar(255) NOT NULL DEFAULT '', 
        `_links_upsell_position` varchar(255) NOT NULL DEFAULT '', 
        `_associated_sku` varchar(255) NOT NULL DEFAULT '', 
        `_associated_default_qty` varchar(255) NOT NULL DEFAULT '', 
        `_associated_position` varchar(255) NOT NULL DEFAULT '', 
        `_tier_price_website` varchar(255) NOT NULL DEFAULT '', 
        `_tier_price_customer_group` varchar(255) NOT NULL DEFAULT '', 
        `_tier_price_qty` varchar(255) NOT NULL DEFAULT '', 
        `_tier_price_price` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `produtos` VALUES   
('RBA01,,Default,simple,Resinas,base,\"Resina: Acrílica Base Água [01 Kg]\",18.9000,/r/e/resina_base_agua_thumb.png,14.9000,0.0000,0.0000,1,0,0,1,1.0000,1,0.0000,1,0,,1,0,1,1,0.0000,1,0,,,,,,,,,,,,,'), 

Answer 1

Your values in the INSERT are inside '' and are a single string for that command.

To elaborate: the error

Column count doesn't match value count

means that a INSERT command don't have the same number of values and columns. In you example, the insert command is with the default value for columns as you didn't inform any, so it will try to insert data in all columns, but as you value are inside ' ', it's treated as a single string.