2 methods better than a thousand words!
Imagine an XML stream composed of a collection of the same family (eg staff), each staff node has N skills and you want to know XSL distinct values of all skills.
With xPATH 2.0, just use the function distinct-values():
With xPATH 1.0, the...
Since MySQL version 5.1 has many happy guys because finally provides support for the partitioning.
To put in context, by analogy with a hard disk, the partitioning of tables allows three main functionalities:
Properly organize their dataFaster...
2 good queries are better than good speech to understand which column choose to group when you want to get the count of a join.
The first query takes 12 seconds:
The second one take only 0.5 seconds:
These two queries produce exactly the same...
I think anyone who has had to analyze large tables to make reporting has already made such queries:
Except imagine that you have 1 million news, MySQL will perform 1 million and 1 queries to retrieve all:
1 query to retrieve 1M news1M queries to...