This repository is related to SQL Joins articles published to TiTrias.com
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
EmployeesDBArticle.sql
LICENSE
README.md
config.json
perf.php
popdb.py

README.md

SQL Joins: Concepts and Performance

This is the source code of the Database articles found on TiTrias.com: Part1: SQL Joins - Difference between Inner Join and Outer Join Part2: SQL Joins - Performance Tips and Tricks & Benchmark

The data included in the SQL File are fake and any similarity between them and real data are just concidence. Library used to generate fake data for performance article can be found here. If you need the populated database contact the author ( > 500MB .sql file)

For the code:

Change the contents of "config.json" according to your MySQL settings.

For the SQL:

1- Extract the files 2- Run the code using the following command:

mysql -u<USERNAME> -p <DATABASE_NAME> < <FILE_NAME>