Python Forum
MYSQL how to assign a table for each user in my username table database?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MYSQL how to assign a table for each user in my username table database?
#1
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!
Reply
#2
(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
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Problem updating value in MySQL database dangermaus33 1 39 Nov-24-2020, 08:32 PM
Last Post: dangermaus33
  Creating table in MySQL db with decimal number issue dangermaus33 7 142 Nov-20-2020, 10:40 PM
Last Post: dangermaus33
  chatterbot utf-8 errors with mysql database isolatedastronaut 0 113 Nov-08-2020, 06:54 AM
Last Post: isolatedastronaut
  I try to import data from Excel table to Word Template. NewbiePyPy 0 129 Oct-21-2020, 12:25 PM
Last Post: NewbiePyPy
  Newbie Start with Text or Table? abrogard 5 216 Oct-18-2020, 12:47 PM
Last Post: jefsummers
  How to check spec table in another df Mekala 0 94 Oct-11-2020, 02:25 PM
Last Post: Mekala
  Unable to Update SQLite Table sambanerjee 5 301 Sep-30-2020, 12:21 PM
Last Post: Larz60+
  Fetch Oracle DB rows & print it in HTML file with table's col headers in table format tssr_2001 1 424 Sep-04-2020, 01:39 PM
Last Post: ibreeden
  How to create db table with SQLite and SQLAlchemy?? marcello86 1 421 Sep-02-2020, 03:05 PM
Last Post: marcello86
  Outlook Emails & HTML Table in Message Body JoeDainton123 1 328 Sep-02-2020, 05:15 AM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020