Pinned Loading

1. Nginx Serve Nginx Serve

   1

   #!/bin/bash

   2

   set -e # exit on error

   3

   4

   # Serve site via Nginx

   5

2. SQL TO CSV SQL TO CSV

   1

   # sql to csv

   2

   select column1, column2 into outfile '/var/lib/mysql-files/output.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from my_table;

   3

   4

   # line count 

   5

   wc -l FILE