jesraygarciano

Commands
Access monitor: mysql -u [username] -p; (will prompt for password)

Show all databases: show databases;

Access database: mysql -u [username] -p [database] (will prompt for password)

Create new database: create database [database];

Select database: use [database];

jesraygarciano

Prettier
Material Theme
Git lens -- Git suercharged
Bracket Pair Colorizer
Beautify

Javascript Standard Style
Javasript (ES6) code snippets

jesraygarciano

Most used commands are: init, clone, status, log, add, commit, reset, rm, branch, checkout, merge, stash

    ## -- Initializing a new git repository
        $$ git init

    ## -- Useful git log commands
        $$ git log --oneline        ## print short sha in one line
        $$ git log -3               ## show only first 3 commit
        $$ git log --author="John"  ## show commits only by this author

jesraygarciano

EXPRESSIONS

    <div id="app">
    <p>I have a {{ product }}</p>
    <p>{{ product + 's' }}</p>
    <p>{{ isWorking ? 'YES' : 'NO' }}</p>
    <p>{{ product.getSalePrice() }}</p>
    </div>

DIRECTIVES

jesraygarciano

 10% building modules 6/12 modules 6 active …resources\assets\js\components\index.jsTypeError: dep.getResourceIdentifier is not a function

****
* npm i webpack@3.11.0 (degrade to @3.11.0)
* NPM install
* npm run dev/watch

****
* npm i webpack
* NPM install

jesraygarciano

S3

require 'aws-autoloader.php';
use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;

Create Bucket

<?php

jesraygarciano

Problem:
./src/pages/Component.vue
vue-loader was used without the corresponding plugin. Make sure to include VueLoaderPlugin in your webpack config

Solution:

Degrade webpack: npm i webpack@3.11.0
                 npm install

then > add Vue loader to Webpack.mix.js

jesraygarciano

A conflict on port 80; since XAMPP used port80 as well as skype. You can use either of these two options:

1:
ServerName localhost:80
Listen 80
to
ServerName localhost:8080
Listen 8080

2:

jesraygarciano

Branching

Quick Legend

Description, Instructions, Notes

Instance	Branch

jesraygarciano

1. Finding Data Queries
SELECT: used to select data from a database

    SELECT * FROM table_name;

DISTINCT: filters away duplicate values and returns rows of specified column

    SELECT DISTINCT column_name;

WHERE: used to filter records/rows