SELECT sample_number AS `internalSampleNo`, sample_quality AS `Samplequality`, sample_other AS `reason`, epithelialcell_abnormal AS `epithelialcells`, pathogen_type AS `pathogen`, cell_change_type AS `NOTtumor`, samplezt AS `ybzt`, squamouscell_abnormal AS `Squamouscell`, glandularcell_abnormal AS `Glandularcell`, picture_path AS `mirrornotice`, judgment AS `Judgment`, supplement AS `supplement`, detection_time AS `Detection`, remark AS `remark` FROM biz_microscope_info WHERE sample_number IN ( 'TCT000000011' ) AND del_flag = '0';行列转换
时间: 2023-07-13 17:17:38 浏览: 52
以下是将该SQL查询结果的行列进行转换的示例代码:
```
SELECT
MAX(CASE WHEN column_name = 'internalSampleNo' THEN value END) AS `internalSampleNo`,
MAX(CASE WHEN column_name = 'Samplequality' THEN value END) AS `Samplequality`,
MAX(CASE WHEN column_name = 'reason' THEN value END) AS `reason`,
MAX(CASE WHEN column_name = 'epithelialcells' THEN value END) AS `epithelialcells`,
MAX(CASE WHEN column_name = 'pathogen' THEN value END) AS `pathogen`,
MAX(CASE WHEN column_name = 'NOTtumor' THEN value END) AS `NOTtumor`,
MAX(CASE WHEN column_name = 'ybzt' THEN value END) AS `ybzt`,
MAX(CASE WHEN column_name = 'Squamouscell' THEN value END) AS `Squamouscell`,
MAX(CASE WHEN column_name = 'Glandularcell' THEN value END) AS `Glandularcell`,
MAX(CASE WHEN column_name = 'mirrornotice' THEN value END) AS `mirrornotice`,
MAX(CASE WHEN column_name = 'Judgment' THEN value END) AS `Judgment`,
MAX(CASE WHEN column_name = 'supplement' THEN value END) AS `supplement`,
MAX(CASE WHEN column_name = 'Detection' THEN value END) AS `Detection`,
MAX(CASE WHEN column_name = 'remark' THEN value END) AS `remark`
FROM (
SELECT 'internalSampleNo' AS column_name, sample_number AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'Samplequality' AS column_name, sample_quality AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'reason' AS column_name, sample_other AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'epithelialcells' AS column_name, epithelialcell_abnormal AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'pathogen' AS column_name, pathogen_type AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'NOTtumor' AS column_name, cell_change_type AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'ybzt' AS column_name, samplezt AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'Squamouscell' AS column_name, squamouscell_abnormal AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'Glandularcell' AS column_name, glandularcell_abnormal AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'mirrornotice' AS column_name, picture_path AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'Judgment' AS column_name, judgment AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'supplement' AS column_name, supplement AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'Detection' AS column_name, detection_time AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
UNION ALL
SELECT 'remark' AS column_name, remark AS value FROM biz_microscope_info WHERE sample_number IN ('TCT000000011') AND del_flag = '0'
) t;
```
这段代码将查询结果的每个字段进行了列转行的处理,并使用 MAX 和 CASE WHEN 结构来确保每个字段的唯一性。