一、正常的SQL
SELECT id, name, age from student;
二、查询出的结果展示前修改为同一类值
SELECT id, 'xuesheng' as name ,age FROM student;
三、列名别名
SELECT id as "SID", name, age FROM student;
转载于:https://www.cnblogs.com/ping-pong/p/9853175.html
SQL语句中的as
一、正常的SQL
SELECT id, name, age from student;
二、查询出的结果展示前修改为同一类值
SELECT id, 'xuesheng' as name ,age FROM student;
三、列名别名
SELECT id as "SID", name, age FROM student;
转载于:https://www.cnblogs.com/ping-pong/p/9853175.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
