From 6b97c1918efffd7aeecbfe34e5921ca1ed3a36b3 Mon Sep 17 00:00:00 2001 From: Andrew Engelbrecht Date: Fri, 19 May 2023 12:25:41 -0400 Subject: [PATCH] uncomment this line to get csv output --- board-forum-contacts.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/board-forum-contacts.sql b/board-forum-contacts.sql index cff3798..c47543d 100644 --- a/board-forum-contacts.sql +++ b/board-forum-contacts.sql @@ -28,5 +28,7 @@ and c.id not in ( ) ) ) -) order by id asc; +) order by id asc +-- into outfile '/var/lib/mysql-files/board-forum-contacts.csv' fields terminated by ',' +; -- 2.25.1