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.
SELECT Parish,parid,Parish,parishname FROM Parish ORDER BY 2.
if not work then tell me more and proper description of your question