What is the usage of sql as

1. as can be used to rename column names or table names. For example, there is a table with two columns: column1 and column2.

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

2, select * from students as ss: Query all data in the students table, and name the students table is ss;

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

3. The query results are displayed in Chinese: select sno as student number,

Sname as student name,

Age as age,

SEX AS sex,

Tel as phone from Students

PHP Chinese Chinese Chinese There are a lot of free SQL tutorials on the Internet, everyone is welcome to learn!

The above is the detailed content of What is the usage of sql as. For more information, please follow other related articles on the PHP Chinese website!