Come in, a few little questions.

Come in, a few questions.
1. How PHP determines if MySQL supports partitioning

2, by the field range partition, everybody knows the program is:

SQL Code

  
   PARTITION by RANGE (check_id) (PARTITION p0 values less THAN (1), PARTITION P1 values less THAN (2), PARTITION P2 values LES S THAN MAXVALUE);

But I do not want to divide by the range, because my field is constant, I want to press the direct equal points (everybody understand), want to achieve the following meaning how to do?

SQL Code

  
   PARTITION by RANGE (check_id) (PARTITION p0 values= (1), PARTITION p1 values= (2), PARTITION p2 values=maxvalue);

Alternatively, the field check_id if it is a string (such as a fixed value A, B, C) can also

3, to the table of the good district, query how to specify the partition query. (because I know the data to be checked is in a section)
For example, I divide the data of the field check_id= "1" into the part_02 of part_01,check_id= "2", then:
SELECT * from text WHERE word= "abc" and Check_id= "1";
Is it possible to write directly:
SELECT * from Text PARTITION (part_01) WHERE word= "ABC"; It's check_id= "1" here, right?

Answer please more details, colleagues!

------Solution--------------------
MySQL's digital divide. Baidu a bit.
------Solution--------------------
Baidu Bar
------Solution--------------------
1. How PHP determines if MySQL supports partitioning
SHOW VARIABLES like '%partition% ';
When no have_partition_engine or value is listed in the query results, it does not support
------Solution--------------------
MySQL supports 5 different partitioning methods
Range partition
List partition
Hash partition
Key partition
Sub-partition

Don't quite understand what kind of method you describe, analyze it yourself
------Solution--------------------
Http://dev.mysql.com/doc/refman/5.1/zh/partitioning.html

There is an introduction to the section in the document. Different partitions are not the same

