I am migrating to MySQL Standard Edition 8.4. In my previous RDBMS environment I organized tables for different purposes into different folders, which I could access programmatically and manually by either specifying the full path of the table directly or first issuing a Change Directory command. How do I replicate this environment in MySQL and use it manually in MySQL Workbench and programmatically in Python?
Thank you for your kind assistance.