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

TedowsGomes — Tue, 19 Nov 2019 17:59:59 GMT

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?)

topic Working with MySQL cursor for a table with huge number of columns. in Integration and Testing

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