does mysql supports inner and outer join when used in php

Question

My project has more of filter things which will require join queries, nested queries to fetch the desired result,there are many filters so my worry is that does php supports these thing at large level because what i know is the MINUS query doesn't work in php(mysql). If anybody had experienced any problem in using joins? if yes then whats the solution??

that set query union , intersect and minus...sorry couldn't explain it properly — agaonsindhe, Nov 28 '12 at 07:40
In practice, whatever runs in the mysql command line client will work in PHP. — Ja͢ck, Nov 28 '12 at 07:41
@anshu.insomniac As you've mentioned in comments you colleagues say that it will cause problems. What kind of problems? If you write awful code you may run in a very bad situation even with simple select query. BTW, any good/advanced ORM uses joins and they work fine. — Leri, Nov 28 '12 at 07:54

score 2 · Accepted Answer · answered Nov 28 '12 at 07:34

2

yep, used several times without any problem

answered Nov 28 '12 at 07:34

Saber Kordestanchi

338
2
10

Are you sure buddy , coz many of my colleagues they are saying that it might coz problems when it will have to fetch larger amount of rows... – agaonsindhe Nov 28 '12 at 07:36
1

I'm sure, used it with large amount of data and it worked just fine :) – Saber Kordestanchi Nov 28 '12 at 07:39
If you're working with reaaaally big amount of data, it's not even preferable to use MySQL alone, just use it with SOLR or something. Or even use MongoSQL. They are much better for scalability – Saber Kordestanchi Nov 28 '12 at 08:41
I don't know what exactly large database is but all i can say is 13 tables after all kind of normalization have been formed and i guess number of rows after deployment would will be uncountable. So u tell me is it large enough to use MongoSQL – agaonsindhe Nov 28 '12 at 08:49
For 13 tables, I don't expect a large system with much scalability needed. But it also depends on the number of hits, your queries and the number of rows. You need a Senior SW Developer who knows all about your system to tell you if it needs scalability or not – Saber Kordestanchi Nov 28 '12 at 08:58
I will talk about it actually before I was working on oracle with java and all of sudden I was instructed to work on mysql and php...thats why i am afraid and asking to much non-sense...thanks for helping if anything happens i will let you know – agaonsindhe Nov 28 '12 at 09:03

score 1 · Answer 2 · edited May 23 '17 at 11:43

1

Joins are related to Date Bases why they will create some issue with PHP, they will work fine... reff for using joins also see Multiple database joins for reff

edited May 23 '17 at 11:43

Community

1
1

answered Nov 28 '12 at 07:37

NoNaMe

6,020
30
82
110

Thats what i thought initially but as my senior colleagues' advised i am li'l bit afraid – agaonsindhe Nov 28 '12 at 07:39
2

check the reff link, not answer of your problem but showing that you can use join in PHP – NoNaMe Nov 28 '12 at 07:40

score 0 · Answer 3 · answered Nov 28 '12 at 07:36

0

It works fine with all the join types. I've worked with all the types and not faced any problem till now.

answered Nov 28 '12 at 07:36

Vamsi

873
1
8
16

does mysql supports inner and outer join when used in php

3 Answers3