This query is for mysql or MariaDB1
2
3
4
5
6select * from (select 'CABECERA' as cabecera
UNION
select apellido_nombre from db.persona) a
limit 10
INTO OUTFILE 'e:\persona.csv'
FIELDS TERMINATED BY ','
This query is for mysql or MariaDB1
2
3
4
5
6select * from (select 'CABECERA' as cabecera
UNION
select apellido_nombre from db.persona) a
limit 10
INTO OUTFILE 'e:\persona.csv'
FIELDS TERMINATED BY ','