|
1、as可以被用作重命名列名或者表名,，如有一張表table，表中有2個列：column1和column2,。 語句：select column1 as 列1,column2 as 列2 from table as 表 2,、select * from students as ss：查詢students表里的所有數(shù)據(jù)，并把students表命名為ss,； 當(dāng)一個表被重命名后,，就可以在下面用ss代替studens：select * from ss 3、查詢結(jié)果以中文顯示：select sno as 學(xué)生號, sname as 學(xué)生名字, age as 年齡, sex as 性別, tel as 電話 from students
|
|
|
