Shicheng-Guo

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

Shicheng-Guo

#!/usr/bin/perl -w
# perl fa2fastq.pl input.fa > output.fastq 
# Contact: Shicheng Guo
# Version 1.3
# Update: 2019-09-08
use strict;

die USAGE() if scalar(@ARGV)<1;
my $file = $ARGV[0];
open FILE, $file;