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.
Samama
0
Newbie Poster
Recommended Answers
Jump to PostWell, 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
thines01
401
Postaholic
Team Colleague
Featured Poster
Samama
0
Newbie Poster
thines01
401
Postaholic
Team Colleague
Featured Poster
Samama
0
Newbie Poster
thines01
401
Postaholic
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.