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

Method fetch

  ``mapping`(`string`:`mixed`) 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.