my query donsn't return any record |
(08-31-2017, 04:43 AM)Narf Wrote: How can a LOWER()ed value start with a capital letter? mysql does not care. abcd is the same as AbCd (depend on the character collation). Does postgresql the same? I believe programmer use mysql and is a beginner. programmer delete an artists or genres and forgot to check if the value is needed. @programmer, A join is in mysql a inner join. If the artist_id or genre_id is null or the id value does not exist in artists/genres you get no records. |
Messages In This Thread |
my query donsn't return any record - by programmer - 08-31-2017, 04:37 AM
RE: my query donsn't return any record - by Narf - 08-31-2017, 04:43 AM
RE: my query donsn't return any record - by Paradinight - 08-31-2017, 12:36 PM
RE: my query donsn't return any record - by php_rocs - 09-01-2017, 12:51 PM
RE: my query donsn't return any record - by Wouter60 - 09-02-2017, 10:36 AM
RE: my query donsn't return any record - by ciadvantage - 09-08-2017, 12:10 PM
|