我这个提取写，我写的sql在mysql中提示语法错误，这是我的语法

Question

这是我的SQL
SELECT ORDER_ID ,1 as ORDER_NO,ICD-10-1 as 'ICD-10' ,NAME1 as 'NAME' ,TYPE1 as 'TYPE' from '病人诊断信息' union all;
SELECT ORDER_ID ,2 as ORDER_NO,ICD-10-2 as 'ICD-10' ,NAME2 as 'NAME' ,TYPE2 as 'TYPE' from '病人诊断信息';

Answer 1

union all 后面的分号; 去掉。
参考如下

SELECT `ORDER_ID` ,"1" as ORDER_NO,`ICD-10-1` as 'ICD-10' ,`NAME1` as 'NAME' ,`TYPE1` as 'TYPE' from `病人诊断信息` 
union all
SELECT `ORDER_ID` ,"1" as ORDER_NO,`ICD-10-2` as 'ICD-10' ,`NAME2` as 'NAME' ,`TYPE2` as 'TYPE' from `病人诊断信息`;