请问这样的表如何处理...mysql
+-----+------------------+--------------+-------------+-----------+-----------+---------+--------+------------+-------------+-----------
| id | filename | ChemistryKit | BinSetName | PanelName | MakerName | BinName | Size | LeftOffset | RightOffSet | Other
+-----+------------------+--------------+-------------+-----------+-----------+---------+--------+------------+-------------+-----------
| 287 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 100 | 99.95 | 0.50 | 0.50 | dark gray
|
| 53 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 100 | 99.96 | 0.50 | 0.29 | dark gray
|
| 288 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 101 | 100.97 | 0.50 | 0.50 | dark gray
|
| 54 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 101 | 100.93 | 0.33 | 0.50 | dark gray
|
| 289 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 102 | 102.11 | 0.50 | 0.50 | dark gray
|
| 55 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 103 | 103.25 | 0.50 | 0.50 | dark gray
|
| 290 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 103 | 103.30 | 0.50 | 0.50 | dark gray
|
| 56 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 104 | 104.34 | 0.50 | 0.50 | dark gray
|
| 291 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 105 | 104.54 | 0.50 | 0.50 | dark gray
|
| 57 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 106 | 105.67 | 0.50 | 0.33 | dark gray
|
| 292 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 106 | 105.68 | 0.50 | 0.26 | dark gray
|
| 293 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 107 | 106.59 | 0.39 | 0.35 | dark gray
|
| 58 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 107(1) | 106.60 | 0.31 | 0.32 | dark gray
|
| 59 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 107(2) | 107.47 | 0.25 | 0.50 | dark gray
|
| 294 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 108 | 107.51 | 0.20 | 0.50 | dark gray
|
| 295 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 109 | 108.68 | 0.50 | 0.32 | dark gray
|
| 60 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 109 | 108.86 | 0.50 | 0.15 | dark gray
|
| 61 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 110(1) | 109.65 | 0.34 | 0.30 | dark gray
|
| 296 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 110(1) | 109.64 | 0.29 | 0.25 | dark gray
|
| 297 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 110(2) | 110.38 | 0.30 | 0.40 | dark gray
|
| 62 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 110(2) | 110.34 | 0.21 | 0.30 | dark gray
|
| 63 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 111 | 111.28 | 0.35 | 0.50 | dark gray
|
| 298 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 111 | 111.31 | 0.26 | 0.50 | dark gray
|
| 299 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 113 | 112.73 | 0.50 | 0.50 | dark gray
|
| 64 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 113 | 112.75 | 0.50 | 0.50 | dark gray
|
| 65 | D:Bin1_1_Bin.txt | 1_1 | 1_1_Bin_Set | 1_1 | Blue | 115 | 115.32 | 0.50 | 0.32 | dark gray
|
| 300 | D:Bin2-1_Bin.txt | 2-1 | 2-1_Bin_Set | 2-1 | Blue | 115 | 115.28 | 0.50 | 0.45 | dark gray
| |
最终得到的形式是
---------------------------------------------------------------------------------------------------------
BinSetName | BinName(51) | BinName(52) | ...................
---------------------------------------------------------------------------------------------------------
1_1_Bin_Set | 0 | 1 | 0 | 1 |0 | 0 | 1
---------------------------------------------------------------------------------------------------------
2_1_Bin_Set | 1 | 1
0 和 1 表示在区间内是否存在值.