Integration and Testing

Authorize.Net API questions and help with your payment integration.

Reply
Member
Posts: 1
Registered: ‎11-19-2019

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