Difference between revisions of "SET FIELDS"

From Lianjapedia
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 23: Line 23:
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|FIELDS]]
 
[[Category:Set_Commands|FIELDS]]
[[Category:Table Basics]]
+
[[Category:NoSQL Commands]]
[[Category:Table Basics Set Commands]]
+

Latest revision as of 12:47, 4 February 2013

Purpose

Specify a list of fields that are accessible in a table

Syntax

SET FIELDS TO <field list> | ALL

SET FIELDS ON | OFF | (<expL>)

See Also

FCOUNT(), FIELD()

Description

The SET FIELDS TO <field list> command defines a list of fields which are accessible from the currently selected table. The SET FIELDS TO ALL command allows all fields to be displayed. The <field list> is not used unless SET FIELDS is ON. The <field list> can only contain fields from the currently selected table. By default FIELDS is OFF, and all fields in the currently selected table are accessible.

Example

use patrons index events
set fields to date, event, name
set fields on
list for date<=date()