MySQL Forums
Forum List  »  MySQL for Excel

run SELECT SINGLE statement from Excel
Posted by: M Tilak
Date: November 21, 2016 01:16PM

Hi all,

I have Excel sheet with say 100 rows and 5 columns.

For each row, do the following:
- I want to run a SELECT SINGLE statement on a mySQL database table.
- For this SELECT statement, the WHERE clause will have values of the 5 columns of the current row.
- Lets say, each SELECT SINGLE returns one row and 3 columns
- I want to get the results of each SELECT statement - filled out in columns 6 through 8 of current row
Repeat this for all 100 rows.

Is there any way to do this without using the IMPORT DATA dialog each time you want to import data?

I can quickly construct the SELECT SINGLE statements for each row. Ideally I would like to do a process only once so that mySQL_for_Excel will get the data for all rows and fill out the results after each row.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
run SELECT SINGLE statement from Excel
1796
November 21, 2016 01:16PM
729
November 29, 2016 04:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.