Skip to content

Latest commit

 

History

History
20 lines (16 loc) · 950 Bytes

README.md

File metadata and controls

20 lines (16 loc) · 950 Bytes
Raw

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>