Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Control the output of SPOOL

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Set colsep'|'; / / Domain output delimiter

Set echo off; / / displays each sql command in the script started by start. The default is on.

Set feedback off; / / echoes the number of records processed by this sql command. Default is on.

Set heading off; / / output domain title, default is on

Set pagesize 0; / / output lines per page. Default is 24. To avoid paging, set it to 0.

Set termout off; / / displays the execution result of the command in the script. Default is on.

Set trimout on; / / removes trailing spaces from each line of standard output. Default is off.

Set trimspool on; / / remove trailing spaces for each line of spool output. Default is off.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report