以文本方式查看主题

-  搭建论坛  (http://bbs.diylsoft.com:8118/starforum/index.asp)
--  数据库交流  (http://bbs.diylsoft.com:8118/starforum/list.asp?boardid=6)
----  问个SQL命令  (http://bbs.diylsoft.com:8118/starforum/dispbbs.asp?boardid=6&id=31311)
--  作者：x123992009
--  发布时间：2011-6-20 20:41:56
--  问个SQL命令

有一个命令是  查询时，数据库中字段名称为。字段1  但我想显示出来的是“名称”

 

望了这么SQL命令这么用的了。。

 

好像是。select  字段1(名称)  from 表

 

不记得是这什么格式了,,知道的说一下.谢谢.
--  作者：xiaoxuesheng
--  发布时间：2011-6-20 23:16:11
--  

我记得应该是：

 

select  字段 as 名称 from 表名
--  作者：dbs
--  发布时间：2011-6-20 23:29:19
--  

SQL Alias

You can give a table or a column another name by using an alias. This can be a good thing to do if you have very long or complex table names or column names.

An alias name could be anything, but usually it is short.

SQL Alias Syntax for Tables

SELECT column_name(s)
FROM table_name
AS alias_name

SQL Alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name

Alias Example

Assume we have a table called "Persons" and another table called "Product_Orders". We will give the table aliases of "p" and "po" respectively.

Now we want to list all the orders that "Ola Hansen" is responsible for.

We use the following SELECT statement:

SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p,
Product_Orders AS po
WHERE p.LastName=\'Hansen\' AND p.FirstName=\'Ola\'

The same SELECT statement without aliases:

SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName
FROM Persons,
Product_Orders
WHERE Persons.LastName=\'Hansen\' AND Persons.FirstName=\'Ola\'

As you\'ll see from the two SELECT statements above; aliases can make queries easier to both write and to read.