sql给表和字段取别名 By yusijia September 03 2016 Updated:September 04 2016 Contents 123456# 表名 别名SELECT t.bookName FROM t_book t WHERE t.id=1;# 属性名 AS 别名SELECT t.bookName AS bName FROM t_book t WHERE t.id=1;