Joins

There are two basic kinds of join:
inner join - matches must be found in joined table
left join - matches do not need to be found in joined table

LEFT JOIN is the same as LEFT OUTER JOIN

Explain Statement

You can get a good indication of how good a join is by taking the product of the values in the rows column of the EXPLAIN output. This should tell you roughly how many rows MySQL must examine to execute the query.
source: http://dev.mysql.com/doc/refman/5.0/en/explain.html

Load a Large MySQL File

On Windows locally from Command Prompt
cd \wamp\mysql\bin
mysql -h localhost -u USER -p DATABASE < "C:\PATH\TO\your_file.sql"

CategoryMysql

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki