MySQL Forums
Forum List  »  General

Need support for MySQL View
Posted by: Nataraja mani
Date: January 22, 2019 04:47AM

Dear team,

I am Working in MySQL 5.7.24 Version.

I need answers for following questions , Could you advise me?
==============================================================

By Default, MySQLdatabase not supported indexing concept in MySQL Views.

1.How to I use the Views in the MySQL Database ?


2.Shall I use the Storedprocedure instead of Views ?


3.Shall I use Dynamic SQl query to Storedprocedure ? Is it Recommended? or Not ?


4.I need to implement Connection pooling ? By default , JDBC Template have the connection pooling , therefore

Shall I use JDBC Template ? Is it Recommended? or Not ?


5.Which is the best one to retrieve the data , Views ? or Stored procedure ? or Both ? could you advice me ?


6.Actually I have one problem with MySQL query.

This is my query

Select json_arrayagg(json_object('Name',Name)) from tbl_test

My table contains arabic strings , When I query the arabic string from JAVA Code.

the result strings are not in readable format . Could you help for my problem ?

Options: ReplyQuote


Subject
Written By
Posted
Need support for MySQL View
January 22, 2019 04:47AM


Sorry, you can't reply to this topic. It has been closed.

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.