The line separator to be used in the output file supported values are: 'unix', 'windows', default to platforms line separator. Use the server connection associated with the session identified by SESSION_ID. Prompt before overwriting DESTINATION if it exists and is not a folder. The output format supported values are: 'csv', 'INSERT', 'excel', 'excel2007', default to 'csv'. The name of the database from which to look up data, default to the connected database.Įnabled debug information sent to stderr. The character set to be used for encoding output supported values are: 'UTF-8' and 'platform-default', default to 'UTF-8'. If both short form and long form are specified on the command line, the long form will take precedence. If DESTINATION is not supplied, the query result is written to standard output. sql for delimited data, Excel file, Excel 2007 file, and INSERT statements respectively. Default extensions are format specific, they are. if DESTINATION does not contain a dot character. Data written to DESTINATION can be in one of these formats: delimited data, Excel file, or INSERT statements see -f option for details.Ī default file extension is assigned to the DESTINATION file if it does not have one, i.e. If no TABLEs are specified, sqlexport attempts to execute the SQL statements stored in shell's SQL buffer, and writes the result of queries to DESTINATION. If more than one TABLEs are specified, DESTINATION is expected to be a folder rather than a file. SYNOPSIS sqlexport ĭESCRIPTION sqlexport retrieves data from the named TABLE(s) and writes the result to the named DESTINATION file. NAME sqlexport - export data from database tables into files
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |