Shulou(Shulou.com)05/31 Report--

This article is about how to use as in sql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. As can be used as a renamed column name or table name. If there is a table table, there are two columns in the table: column1 and column2.

Statement: select column1 as column 1 column 2 as column 2 from table as table

2. Select * from students as ss: query all the data in the students table and name the students table ss

When a table is renamed, you can use ss instead of studens:select * from ss below

3. The query result is displayed in Chinese: select sno as student number.

Sname as student name

Age as age

Sex as gender

Tel as phone from students

Thank you for reading! This is the end of the article on "how to use as in sql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.