设置像MySQL这样的大查询变量 [英] Setting Big Query variables like mysql

问题描述

什么是与mysql变量类似的bigquery？

what is the bigquery equivalent to mysql variables like?

SET @fromdate = '2014-01-01 00:00:00',  -- dates for after 2013
@todate='2015-01-01 00:00:00',

@bfromdate = '2005-01-01 00:00:00', -- dates for before 2013
@btodate = '2005-01-01 00:00:00',

@achfromdate  = '2013-01-01 00:00:00', -- dates for ACH without submit time in 2013
@achtodate  = '2013-01-01 00:00:00',

@currency="USD";

推荐答案

在BigQuery中没有要设置的变量，但是您可以添加功能请求： https： //code.google.com/p/google-bigquery/issues/list?q=label:Feature-Request

There are no 'variables' to be set in BigQuery, but you could add a feature request: https://code.google.com/p/google-bigquery/issues/list?q=label:Feature-Request

这篇关于设置像MySQL这样的大查询变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！