Page History

NAME
      go - execute database statements

SYNOPSIS
      go [OPTION]

DESCRIPTION
      Send the contents of the Work Buffer to the database. It then displays the results of the query and returns, causing the Work Buffer to be cleared and moved
      to the end of the History Buffer.

OPTIONS
      -i VARIABLE_NAME=COLUMN_INDEX
      Save the value of the cell at row 1 and column index COLUMN_INDEX into shell variable VARIABLE_NAME. COLUMN_INDEX is 1-based. This option can be repeated.

      -k, --session-id SESSION_ID
      Use the server connection associated with the session identified by SESSION_ID.

      -n VARIABLE_NAME=COLUMN_NAME
      Save the value of the cell at row 1 with name COLUMN_NAME into shell variable VARIABLE_NAME. This option can be repeated.

EXAMPLES

$ select top 25 * from orders
$ go

      To redirect the output of the select statement to a file, use the command go together with >>. SQL statements and the symbols / @ or ; cannot be combined 
      with redirection and pipelines.

$ select top 25 * from orders
$ GO >> rows.txt

      
      Execute a query on the currently connected server and save the values of the first two columns of the first row to shell variables 'v_one' and 'v_two':

SELECT * FROM table
go -i v_one=1 -i v_two=2

      Execute a query on the currently connected server and save the values of columns 'c2' and 'c3' of the first row to shell variables 'v_one' and 'v_two':

SELECT c1, c2, c3 FROM table
go -n v_one=c2 -n v_two=c3

NOTES
      For -i and -n options, a new variable is created if the specified variable does not exist; if the query returns nothing, an empty string is saved to the specified variable. 
      If the specif ied variables already exist but query execution failed, the contents of existing variables will n ot be cleared.

      If two different columns are specified by -i and -n options but both of them point to the same variable, the value of the column specified by -n is used.

SEE ALSO
      source