Fastest Web Hosting

how to reduce select statement in mysql

0 votes
asked May 24, 2016 in Mysql by anonymous

i have developed a program in php where i used many sql queryies to display profile of user.
like Member Detail, City Details, Contact Detail, Eduction Detail..these are different different tables.so i have to used many sql queries. But i can not create same table for all these content because these tables are used many places...so if you have any solution Plz Help!

1 Answer

0 votes
answered Aug 9, 2016 by samkitkanadia (140 points)

One solution is use joins. You does not need to fire multiple queries. another solution is that use stored procedure. for more details visit this link. http://www.w3schools.com/sql/sql_join.asp

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's
...