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, or null if the column is the result of an expression or subquery. This property is the result of sqlite3_column_origin_name().

  • database <string> | <null> 原始数据库的未别名,如果该列是表达式或子查询的结果,则为 null。此属性是 sqlite3_column_database_name() 的结果。

    \database <string> | <null> The unaliased name of the origin database, or null if the column is the result of an expression or subquery. This property is the result of sqlite3_column_database_name().

  • name <string> 分配给 SELECT 语句结果集中的列的名称。此属性是 sqlite3_column_name() 的结果。

    \name <string> The name assigned to the column in the result set of a SELECT statement. This property is the result of sqlite3_column_name().

  • table <string> | <null> 原始表的未别名,如果该列是表达式或子查询的结果,则为 null。此属性是 sqlite3_column_table_name() 的结果。

    \table <string> | <null> The unaliased name of the origin table, or null if the column is the result of an expression or subquery. This property is the result of sqlite3_column_table_name().

  • type <string> | <null> 列的声明数据类型,如果列是表达式或子查询的结果,则为 null。此属性是 sqlite3_column_decltype() 的结果。

    \type <string> | <null> The declared data type of the column, or null if the column is the result of an expression or subquery. This property is the result of sqlite3_column_decltype().

此方法用于检索有关准备好的语句返回的列的信息。

\This method is used to retrieve information about the columns returned by the prepared statement.