Created
April 7, 2016 11:33
-
-
Save drvenabili/6b3ee2ed281f5b0772253477163b9373 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
echo "SELECT "server_time", "piwik_log_action.name" AS "url" FROM "piwik_log_link_visit_action" JOIN "piwik_log_action" ON "piwik_log_link_visit_action.idaction_url" = "piwik_log_action.idaction" WHERE "idsite" =16 AND "server_time" > \"2016-01-01 00:00:00\" AND "server_time" < \"2016-03-31 00:00:00\" ORDER BY "server_time";" | mysql -u root -pljungan piwik2; | |
# TODO : variables pour les dates | |
# Remplacer les credentials à la fin |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
thx!