statement.columns()
-
返回:<Array> 对象数组。每个对象对应于准备好的语句中的一列,并包含以下属性:
¥Returns: <Array> An array of objects. Each object corresponds to a column in the prepared statement, and contains the following properties:
-
column:<string> | <null> 原始表中列的未别名,如果该列是表达式或子查询的结果,则为null。此属性是sqlite3_column_origin_name()的结果。¥
column: <string> | <null> The unaliased name of the column in the origin table, ornullif the column is the result of an expression or subquery. This property is the result ofsqlite3_column_origin_name(). -
database:<string> | <null> 原始数据库的未别名,如果该列是表达式或子查询的结果,则为null。此属性是sqlite3_column_database_name()的结果。¥
database: <string> | <null> The unaliased name of the origin database, ornullif the column is the result of an expression or subquery. This property is the result ofsqlite3_column_database_name(). -
name:<string> 分配给SELECT语句结果集中的列的名称。此属性是sqlite3_column_name()的结果。¥
name: <string> The name assigned to the column in the result set of aSELECTstatement. This property is the result ofsqlite3_column_name(). -
table:<string> | <null> 原始表的未别名,如果该列是表达式或子查询的结果,则为null。此属性是sqlite3_column_table_name()的结果。¥
table: <string> | <null> The unaliased name of the origin table, ornullif the column is the result of an expression or subquery. This property is the result ofsqlite3_column_table_name(). -
type:<string> | <null> 列的声明数据类型,如果列是表达式或子查询的结果,则为null。此属性是sqlite3_column_decltype()的结果。¥
type: <string> | <null> The declared data type of the column, ornullif the column is the result of an expression or subquery. This property is the result ofsqlite3_column_decltype().
-
此方法用于检索有关准备好的语句返回的列的信息。
¥This method is used to retrieve information about the columns returned by the prepared statement.