You can save the output into a file using the SELECT INTO OUTFILE statement.
You can specify the column and line delimiters, and later you can import the data into other data platforms.
Selecting data into a file and table
Get MySQL 8 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
