Difference between revisions of "SET FIELDS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Specify a list of fields that are accessible in a table | Specify a list of fields that are accessible in a table | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 7: | Line 6: | ||
SET FIELDS ON | OFF | (<expL>) | SET FIELDS ON | OFF | (<expL>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[FCOUNT()]], [[FIELD()]] | + | [[FCOUNT()]], [[FIELD()]] |
| − | + | ||
==Description== | ==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. | 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== | ==Example== | ||
| Line 24: | Line 20: | ||
list for date<=date()</code> | list for date<=date()</code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|FIELDS]] | [[Category:Set_Commands|FIELDS]] | ||
| − | [[Category: | + | [[Category:NoSQL Commands]] |
| − | + | ||
Latest revision as of 12:47, 4 February 2013
Contents
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
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()
