别名问题
SELECT id,empname AS 姓名,empsalary AS 薪水 FROM empinfo ;
empname 为varchar,empsalary 为float(8,6),错误提示empsalary AS 薪水 FROM empinfo ;
SELECT id,empname AS 姓名,empsalary AS 薪水 FROM empinfo ;
empname 为varchar,empsalary 为float(8,6),错误提示empsalary AS 薪水 FROM empinfo ;
2018-03-19
举报