/learn-sql

Primary LanguageTSQL

Setup

  1. git clone https://github.com/mutan/learn-sql
  2. cd learn-sql
  3. composer install
  4. Go on with current book instructions

Documentation

Phinx: Github | phinx.org

Books

1. Learning SQL. Alan Beaulieu. 2007

  1. Create database beaulieu (or whatever, but then change it in phinx-beaulieu.yml and in migration file in beaulieu/migrations/
  2. bash refresh.sh phinx-beaulieu.yml

To rollback:

vendor/bin/phinx rollback -c phinx-beaulieu.yml -t 0

2. SQL Cookbook. Anthony Molinaro. 2009

  1. Create database molinaro (or whatever, but then change it in phinx-molinaro.yml)
  2. bash refresh.sh phinx-molinaro.yml

To rollback:

vendor/bin/phinx rollback -c phinx-molinaro.yml -t 0

XAMPP MySQL command line

cd c:\xampp\mysql\bin
./mysql.exe -u root --password or simple ./mysql