Skip to content

Instantly share code, notes, and snippets.

View mmendozadelsolar's full-sized avatar

Martin mmendozadelsolar

2 followers · 5 following
View GitHub Profile
@mmendozadelsolar
mmendozadelsolar / README.md
Created February 24, 2018 19:05 — forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet
@mmendozadelsolar
mmendozadelsolar / Pull-and-Sync-Data-Between-Google-Doc-Spreadsheet-and-MySQL.gs
Created September 13, 2017 06:23
You can pull data from MySQL database to Google doc spreadsheet auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format.
// MySQL to Google Spreadsheet By Pradeep Bheron
// Support and contact at pradeepbheron.com
function myMySQLFetchData() {
var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials
var stmt = conn.createStatement();
var start = new Date(); // Get script starting time
@mmendozadelsolar
mmendozadelsolar / mysql_backup.py
Created April 13, 2017 07:58
#!/usr/bin/python
#Author: Jelle Bekker
#Base for this script was created by: Andrew McDonald [email protected] http://mcdee.com.au
# Example: config file
#[client]
#host = localhost
#user = root
#password = root-pass