MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: populate a table in mysql from google spreadsheets with app script
Posted by: Peter Brawley
Date: March 07, 2021 10:49AM

No need here for PHP.

Write the google spreadsheet to a .csv file.

Read about secure_file_priv in the MySQL manual, set it to a convenient folder. restart MySQL.

Move the .csv file to that folder.

Read about Load Data Infile in the MySQL manual.

Create an appropriate table.

Form your Load Data cmd, run it in the mysql client program.



Edited 1 time(s). Last edit at 03/07/2021 10:49AM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
populate a table in mysql from google spreadsheets with app script
Gerry Garcia
March 07, 2021 05:16AM
Re: populate a table in mysql from google spreadsheets with app script
Peter Brawley
March 07, 2021 10:49AM
Re: populate a table in mysql from google spreadsheets with app script
Rina Agatha
March 08, 2021 08:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.