so i have to build an application where i have to read values from a csv file(excel)and insert them in mySQL.i can do the reading part however I'm fairly stumped by how do i insert the values to the database.
Any help regarding this matter is apprecaited.
Jump to Post
Well, that can be quite extensive depending on the schema of your database and the number of column.
The correct way would be to create a prepared statement with SQL parameters that you fill on each loop.
The simple (less-efficient) way would be to create a new SQL string each …
All 5 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.