Compute imported csv data to MySQL

I’m trying to import data from csv to our mysql database, so far I have no problems with the other columns, but some of our columns are calculated

Here’s my code so far:


I wanted to be able to compute the data pulled from the qty and cost column so that when its inserted into the database it would be computed but I’m having an error.

Any suggestions on how I can fix this?

Thank you

Since it’s coming from csv data, I’m going to guess that qty and cost are both strings.

ah yes you’re right


so i would have to declare or convert those into integers then?

its working now, thank you