使用 AS
用法: TABLE AS 別名
例:SELECT u.id,u.username FROM user AS u;
用法:欄位 AS 別名
例:
SELECT
COUNT(username) AS user_name_count,
id AS user_id
FROM
user AS u;
用法: TABLE 別名
例:
SELECT u.id,u.username
FROM user u;
用法:欄位 別名
SELECT
COUNT(username) user_name_count,
id user_id
FROM
user u;
其它文章
留言列表