MySQL Forums
Forum List  »  Newbie

Fetching multiple values with single select
Posted by: Eran Yasso
Date: July 19, 2018 12:41AM

Hi,

I have two questions:

1. I need to fetch imageUrl and productName for products using productId.
The problem is the the productIds are not continues (so i can't user range). This means that if I have 100 products I will need to have 100 calls per product. Is there any option to do that instead of making 100 calls?

2. I have an order object (which includes 4 sub arrays and other class members) which I want to save in the db (C# class). I don't need to do select on that record. Only store and and fetch it. What is the best way to store it? I was thinking of serializing it as json string and store it as string.
The string can be very large. Is there any better way to store objects than serializing it to json?

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
Fetching multiple values with single select
July 19, 2018 12:41AM


Sorry, only registered users may post in this forum.

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.