- SQL
- Docker
- Beekeeper Studio
- MariaDB
The code begins with simple queries like selecting columns and finding substrings to narrow information, and then on to subqueries. Next is updating columns and also adding to them. I use aggregation on tables and filter then to find particular details. The last three blocks of code use different joins on table id's to find what they have in common.
- Clone this repository onto your machine.
- In your command line, run ./start_db.sh
- Open Beekeeper Studio and start a new connection(Connection type: MariaDB, Host: localhost, Port: 3306, User: root, Password: mysql) and connect
- Select lego from the left dropdown list
- Type in 'show tables' to check that you're connected to the lego database
- Now you can input the code I've written to see how it works
Possible incorrect code here:
- UPDATE inventory_parts SET quantity = quantity * 2 WHERE quantity > 1;
- SELECT * FROM inventory_parts ORDER BY quantity LIMIT 20;
If you have any questions or concerns, please email me at jarretjeter@gmail.com
MIT Copyright (c) 04/23/2022 Jarret Jeter