Python Forum
MYSQL how to assign a table for each user in my username table database? - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/Forum-Python-Coding)
+--- Forum: General Coding Help (https://python-forum.io/Forum-General-Coding-Help)
+--- Thread: MYSQL how to assign a table for each user in my username table database? (/Thread-MYSQL-how-to-assign-a-table-for-each-user-in-my-username-table-database)



MYSQL how to assign a table for each user in my username table database? - YoshikageKira - Dec-25-2019

So I have a mysql database with a table that stores each individual's username and password and ID. How do I assign a new table for each individual user when a signal is called (EX: when the user creates a new account, a new table is created for them and only them) or Another example being if the user logs off and logs back in, his/hers data in the tables will be still be stored from last. I think you get the point.


Thank you!


RE: MYSQL how to assign a table for each user in my username table database? - buran - Dec-26-2019

(Dec-25-2019, 10:58 PM)YoshikageKira Wrote: when the user creates a new account, a new table is created for them and only them)
that (table per each user) is very poor DB schema design. You really should not do this. Imagine what will happen with table count when number of users raise