11-19-2019 09:59 AM
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?)