MySql查询一张表中不同字段再组装成新字段
SELECT t1.alert_des_data, t2.alert_level_data FROM ( SELECT alert_des_data FROM test_dhfk ) t1, ( SELECT alert_level_data FROM test_dhfk ) t2
alert_des_data | alert_level_data |
---|---|
无 | 1 |
SELECT t1.alert_des_data, t2.alert_level_data FROM ( SELECT alert_des_data FROM test_dhfk ) t1, ( SELECT alert_level_data FROM test_dhfk ) t2
alert_des_data | alert_level_data |
---|---|
无 | 1 |