I have 2 collumns in a single calc spreadsheet. The first is a number code for a company (a primary key). The second, I must populate with the name of this company.
I also have one table with 2 fields into a MySQL, accessed thought jdbc by my Libreoffice.This table have 2 fields: company_id is the first one and it’s a number, the primary key of the register. company_name, the second one, it’s the name I must retreive to the calc spreadsheet.
How can I query the mysql db, using the first column of the spreadsheet to retreive the company_name to put at second column?