java - CSV to MySQl Import -

i need insert csv mysql database in proper column.

let csv has header , info b c

and mysql has table column c b

i need know best way insert csv info mysql table

i believe can utilize next syntax mysql:

"insert users (username, password, email, firstname, lastname, createdate) values ('test', 'test', 'test', 'test', 'test', 'test')"

so can build query, using header , column falls into, (pseudocode):

"insert table (header1, header2, header3) values (column1, column2, column3)"

regardless of order info in table, insert info right column.

java mysql sql

Three