TRUNCATE inventario;
LOAD DATA INFILE 'C:\\files\\INVENTARIO_MILSA_02_08_2025.csv' INTO TABLE inventario FIELDS TERMINATED BY '|' ENCLOSED BY '@' ESCAPED BY '' LINES TERMINATED BY '\n'  IGNORE 1 LINES(
 @col1,
 @col2,
 @col3,
 @col4,
 @col5
 ) set 
categoria=@col1,
subcategoria=@col2,
descripcion=@col3,
existencia=@col4,
unidad=@col5, 
ubicacion = "Almacen 1",
created_at=NOW();