Exporting with a SQL script

To import with a SQL script, you can run this code:

SELECT * INTO OUTFILE 'teams-export.csv'
 FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
 LINES TERMINATED BY '
'
 FROM yourschema.teams;

When your export is done, you will have a CSV file on disk that will look like the following screenshot when it's opened:

As long as your secure-file-priv option is not disabled, your script will appear in the folder configured in secure-file-priv.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

18.191.253.62

Table of Contents for Exporting with a SQL script&#xA0;