Setup
git clone https://github.com/mutan/learn-sql
cd learn-sql
composer install
- Go on with current book instructions
Documentation
Books
1. Learning SQL. Alan Beaulieu. 2007
- Create database
beaulieu
(or whatever, but then change it inphinx-beaulieu.yml
and in migration file inbeaulieu/migrations/
bash refresh.sh phinx-beaulieu.yml
To rollback:
vendor/bin/phinx rollback -c phinx-beaulieu.yml -t 0
2. SQL Cookbook. Anthony Molinaro. 2009
- Create database
molinaro
(or whatever, but then change it inphinx-molinaro.yml
) 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