Method Mysql.SqlTable()->Result()->fetch()

Method fetch

mapping(string:mixed)|zero fetch()

Description

Fetches the next record from the result and advance the cursor. Returns zero if there are no more records.

The record is returned as a mapping. It is similar to the mappings returned by Sql.query, except that native pike types and Val.null are used. If prop_col is used then properties from that column can be returned as mapping entries alongside the columns, and those values can be any pike data type.

As opposed to the Sql.query mappings, the returned mapping has a single entry for each field - there are no duplicate entries prefixed with the table name.