更新时间:2024-07-02 GMT+08:00
分享

DESCRIBE OUTPUT

语法

DESCRIBE OUTPUT statement_name

描述

列举预编译语句prepared statement的输出列,包括列名(或者别名),catalog,schema,表名,类型,类型的大小(in bytes),以及一个boolean 值标识是否为别名。

示例

--PREPARE my_select1 FROM SELECT * FROM fruit;
  DESCRIBE OUTPUT my_select1;
--PREPARE my_select2 FROM SELECT count(*) as my_count, 1+2 FROM fruit;
  DESCRIBE OUTPUT my_select2;
--PREPARE my_create FROM CREATE TABLE foo AS SELECT * FROM fruit;
  DESCRIBE OUTPUT my_create;

相关文档