Sql out file formate

SELECT customer_id, firstname, surname INTO OUTFILE 'E:/exportdata/customers.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM customers;

Source: mariadb.com

Similar codes

0 vote211 views1 answer
How to add mysql to path on termin after installation
SQL
8 votes170 views1 answer
How to remove tables from postgresql
SQL
5 votes200 views2 answers
Get columns number sql
SQL
0 vote256 views1 answer
How to add auto increment primary key
SQL
-1 vote166 views1 answer
Plsql while
SQL
1 vote250 views1 answer
Cannot drop database because it is currently in use
SQL
-1 vote186 views1 answer
Select first rows postgresql
SQL
0 vote236 views1 answer
Python mysql executemany
SQL
4 votes194 views1 answer
Mysql ip address data type
SQL
15 votes182 views6 answers
Psql
SQL