Welcome Guest, Not a member yet? Register   Sign In
my query donsn't return any record
#3

(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.
Reply


Messages In This Thread
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



Theme © iAndrew 2016 - Forum software by © MyBB