サイレント接続

• MySQL

(8.0.29)

drop table tab1;
create table tab1(col1 int,col2 varchar(30) );
insert into tab1 values(1234567890,'1234567890');
insert into tab1 values(1234567890,'1234567890');

select * from tab1;

mysql --silent --skip-column-names test -e "select * from tab1;" | sed 's/\t/,/g'

• Oracle

(19c)

drop table tab1 purge;
create table tab1(col1 int,col2 varchar2(30) );
insert into tab1 values(1234567890,'1234567890');
insert into tab1 values(1234567890,'1234567890');
commit;

select * from tab1;

sqlplus -S test/test@pdb1 <<EOF
set head off
set markup csv on
select * from tab1;
EOF

• PostgreSQL

(14)

drop table tab1;
create table tab1(col1 int,col2 varchar(30) );
insert into tab1 values(1234567890,'1234567890');
insert into tab1 values(1234567890,'1234567890');

select * from tab1;

psql --quiet --tuples-only --field-separator="," --no-align -c "select * from tab1;" test

• SQL Server

(2019)

drop table tab1;
create table tab1(col1 int,col2 varchar(30) );
insert into tab1 values(1234567890,'1234567890');
insert into tab1 values(1234567890,'1234567890');

select * from tab1;

sqlcmd -h -1 -s "," -W -d test -Q "set nocount on; select * from tab1;"