This repo is a MySQL Instagram Dataset clone and includes some Challenges to play with the data. I learned this at The Ultimate MySQL Bootcamp at Udemy.
1.Download MySQL Workbench.
2.Start MySQL Server & Open MySQL Workbench.
3.Run run.sql via File => Run SQL Script.
4.Run run.sql via File => Run SQL Script.
File => Open SQL Script and open use.sql and execute it.
Now we are using instagram_clone_db schema.
File => Open SQL Script and open set_sql_mode.
Create these below queries with File => New Query Tab (or, use MySQL Workbench UI for the same)
SELECT * FROM users;
SELECT * FROM photos;
SELECT * FROM comments;
SELECT * FROM likes;
SELECT * FROM follows;
SELECT * FROM tags;
SELECT * FROM photo_tags;