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
Photo Converting Pandas DataFrame to a table of hourly blocks Abedin 1 579 Apr-24-2025, 01:05 PM
Last Post: snippsat
  Pinball table CCC fourbanks 0 424 Mar-09-2025, 03:10 PM
Last Post: fourbanks
  working with pivot table gunther 1 438 Jan-22-2025, 08:55 AM
Last Post: Keville_35
  Convert Json to table format python_student 4 14,902 Dec-05-2024, 04:32 PM
Last Post: Larz60+
  Extracting table and table name from PDF vinibhat 4 7,723 Aug-10-2024, 07:29 AM
Last Post: Pedroski55
  checking username newbexx 3 1,175 Jun-17-2024, 11:42 AM
Last Post: Pedroski55
  drawing a table with the status of tasks in each thread pyfoo 3 1,456 Mar-01-2024, 09:29 AM
Last Post: nerdyaks
  How to create a table with different sizes of columns in MS word pepe 8 8,392 Dec-08-2023, 07:31 PM
Last Post: Pedroski55
  Trying to get counts/sum/percentages from pandas similar to pivot table cubangt 6 3,429 Oct-06-2023, 04:32 PM
Last Post: cubangt
  Mysql and mysql.connector error lostintime 2 1,722 Oct-03-2023, 10:25 PM
Last Post: lostintime

Forum Jump:

User Panel Messages

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