使用查找表将数据从csv字段导入数据库字段

Question

I wish to import data from a csv spreadsheet into an empty database field named "parishname" that normally uses a lookup table to add data using the query -

SELECT "Parish"."parid","Parish"."parishname" FROM "Parish" ORDER BY 2.

Can someone give me the code required to amend the query to allow data in the csv field to bypass the query. I have little or no MYSQL knowledge and am using Appgini software to build the database.

Answer 1

SELECT Parish,parid,Parish,parishname FROM Parish ORDER BY 2.


if  not work then tell me more and proper  description of your question