Confused about syntax for specific join with 3 tables

I've been doing some experimenting with the data model from the "MySQL" book (Addison Wesley). I have no trouble understanding joins between two tables, but I'm finding it's a little confusing when 3 or more tables are involved. I'm going to cite a particular set of tables and a specific quer

How to change where NULL values sort?

I think normally NULL values will sort at the end, correct? I believe there's a way to make NULL values sort at the beginning, but I can't remember how to do it. I just searched a couple of MySQL resources, but I couldn't find it. -- MySQL General Mailing List For list archives: http://lists

How to set db property so that table name queries are case-insensitive?

Ubuntu 8.10. I was experimenting with the Spring Petclinic sample application, configured with MySQL. I found that some of the tests were failing, apparently because of table name case-sensitivity issues. I was able to fix some of the code references, but after that I hit other, probably fo

Re: best mysql optimization tutorial and/or quick start guide?

John G. Heim wrote: - Original Message - From: "Darryle Steplight" To: "Stephen Edberg" Cc: "John G. Heim" ; Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High Performance MySql "Optimization, Backups, Replication,

Re: W2008 Server Issues?

Duncan, Kurt (MCUSA) wrote: 1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are

Re: Query from HPM book to limit rows scanned doesn't appear to work as described

Baron Schwartz wrote: Hi! On Wed, Mar 11, 2009 at 8:20 PM, David M. Karr wrote: Using 5.0.67-0ubuntu6 on Ubuntu 8.10. I'm going through the "High Performance MySQL" book. I was reading section 4.4.1.8, titled "MIN() and MAX()". The point of this is that MySQL d

Query from HPM book to limit rows scanned doesn't appear to work as described

Using 5.0.67-0ubuntu6 on Ubuntu 8.10. I'm going through the "High Performance MySQL" book. I was reading section 4.4.1.8, titled "MIN() and MAX()". The point of this is that MySQL doesn't optimize MIN()/MAX() very well, but it showed a supposed workaround for this. The first sample query w

URL for detailed description of SQL left/right inner/outer join concepts?

Is there a good URL that explains in detail exactly the concepts of SQL left/right inner/outer join? I've found several that give very high-level hints, but nothing that really summarizes exactly what these do. -- === Da

Re: high level: enabling transactions in mysql-max with WebLogic TX datasource?

None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files? -- ==

high level: enabling transactions in mysql-max with WebLogic TX datasource?

sing a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- ===