cancel
Showing results for 
Search instead for 
Did you mean: 

Working with MySQL cursor for a table with huge number of columns.

I am writing a procedure to convert data from multiple smaller tables into a 'flat' table with many columns(~100).

I have a cursor defined which reads/joins data from smaller tables.

So far I have seen that 'fetch' semantics works with explicit variables in mysql. Is there a way where I can do something like: 'fetch * from cursor; followed by insert'?

Following is a sample (for single field insert).

How to deal if let's say temp and jsontable had 50 columns. (fetching into 50 explicit variables or is there a better way?)

TedowsGomes
Member
0 REPLIES 0