获得第一张唱片 [英] Get the First record

问题描述

大家好，


是否有MySQL函数通过查询获取第一条记录？我想打开一页

客户记录，显示第一个。其他记录可以从超链接列表中访问。


感谢您的任何建议，


Rick

Hi all,

Is there a MySQL function to get the first record through a query? I would like to open a page of
client records with the first one shown. The other records can be accessed from a hyperlinked list.

Thanks for any advice,

Rick

推荐答案

Rick写道：

是否有MySQL函数通过
查询获取第一条记录？我想打开一页客户记录，首先显示
。其他记录可以从
超链接列表中访问。

Is there a MySQL function to get the first record through a
query? I would like to open a page of client records with the
first one shown. The other records can be accessed from a
hyperlinked list.

定义第一条记录 :)


就数据库而言，没有这样的东西。如果你想从数据库中检索单个记录，请在查询中说明：


从数据库中选择* one *记录：

select< field，list>来自< tables>其中< conditions>

LIMIT 1


从数据库中选择*第一条记录*

select< field，list> ;来自< tables>其中< conditions>

ORDER BY< sort，fields>限制1

-

- =我的邮箱只接受= -

- = Content-Type：text / plain = -

- =大小低于10001字节= -

Define "first record" :)

There is no such thing as far as the database is concerned. If you want
to retrieve a single record from the database say so in the query:

select *one* record from the database:
select <field, list> from <tables> where <conditions>
LIMIT 1

select *the first record* from the database
select <field, list> from <tables> where <conditions>
ORDER BY <sort, fields> limit 1
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

如果你只想从未知数字返回第一行然后添加

" LIMIT 1 OFFSET 0"到SELECT语句。查看
上的语法 http：/ /www.mysql.com/documentation/m...ax.html#SELECT


-

Tony Marston

http://www.tonymarston.net

Rick < [e-mail]>在消息中写道

news：11Y0c.97758

If you only want to return the first row from an unknown number then add
"LIMIT 1 OFFSET 0" to the SELECT statement. Check out the syntax at
http://www.mysql.com/documentation/m...ax.html#SELECT

--
Tony Marston

http://www.tonymarston.net
"Rick" <[e-mail]> wrote in message
news:11Y0c.97758

Xp.432840@attbi_s54 ...

Xp.432840@attbi_s54...

大家好，

是否有MySQL函数通过查询获取第一条记录？我想
喜欢用显示的第一个打开一页客户记录。其他记录可以从超链接列表中访问
。
感谢任何建议，

Rick

Hi all,

Is there a MySQL function to get the first record through a query? I would like to open a page of client records with the first one shown. The other records can be accessed from a hyperlinked list.
Thanks for any advice,

Rick

这篇关于获得第一张唱片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！