jmilagroso

# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

jmilagroso

Route::get('redis', array('as' => 'cache', 'do' => function()
{
    $redis = Redis::connection();

    //STRING
    $redis->set('name', 'Taylor');
    $name = $redis->get('name');

    //  LIST
    //  A list is a series of ordered values. Some of the important commands for interacting with lists are RPUSH, LPUSH, LLEN, LRANGE, LPOP, and RPOP.

jmilagroso

<?php

/**
 * EventDate class helper.
 *
 * @author Jay Milagroso<j.milagroso@gmail.com>
 */
class EventDate {

  // Today

jmilagroso

{
  "Version":"2012-10-17",
  "Statement":[{
	"Sid":"PublicReadGetObject",
        "Effect":"Allow",
	  "Principal": "*",
      "Action":["s3:GetObject"],
      "Resource":["arn:aws:s3:::example-bucket/*"
      ]
    }

jmilagroso

#!/usr/bin/env bash

echo ">>> Starting Install Script"

# Update
sudo apt-get update

# Install MySQL without prompt
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password root'
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password root'

jmilagroso

# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so

# Packages #

jmilagroso

SELECT * INTO OUTFILE 'C:/export/users.csv' 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM users;

jmilagroso

1 Mach = 340.29 m / s
1 m/s = 3.6 km/h
 
1.5 Mach = 510.435 m/s
((510.435 m/s)x(3.6 km/h))/(1m/s) = 1837.566 km/h

 FA-50 Velocity is 1837.566 km/h

jmilagroso

UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), 
                             SUBSTRING(CompanyIndustry, 2));

jmilagroso

DELIMITER $$

CREATE TRIGGER after_delete_on_table_a AFTER DELETE ON table_a
FOR EACH ROW  
BEGIN  
    DELETE FROM table_b WHERE table_b.foreign_id = old.id;
END