SELECT device_id AS user_infos_example FROM user_profile LIMIT 2;
其实还有一种视图写法,但是该题目不给创建视图的权限。。雷姆
CREATE VIEW ssd AS SELECT device_id AS user_infos_example FROM user_profile; SELECT * FROM ssd LIMIT 2;
SELECT device_id AS user_infos_example FROM user_profile LIMIT 2;
其实还有一种视图写法,但是该题目不给创建视图的权限。。雷姆
CREATE VIEW ssd AS SELECT device_id AS user_infos_example FROM user_profile; SELECT * FROM ssd LIMIT 2;