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
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 930 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  Remove Blank Lines from docx table and paragraphs bsudhirk001 1 248 Feb-14-2021, 12:38 AM
Last Post: Larz60+
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 211 Feb-05-2021, 04:37 PM
Last Post: nilamo
  write mariadb table rows query to each file? shams 1 205 Feb-02-2021, 04:10 PM
Last Post: buran
  Convert table in pandas tgottsc1 2 265 Jan-26-2021, 01:58 PM
Last Post: tgottsc1
  How to update values in a pyarrow table? xraphael75 1 383 Jan-25-2021, 02:14 PM
Last Post: xraphael75
  Populate a table with variables Market_Python 4 377 Jan-11-2021, 09:45 AM
Last Post: Pedroski55
  Data extraction from a table based on column and row names tgottsc1 1 439 Jan-09-2021, 10:04 PM
Last Post: buran
  How i can add elements to table index of element blazej2533 3 310 Dec-03-2020, 08:16 PM
Last Post: Larz60+
  Load data from One oracle Table to Multiple tables amy83 1 274 Dec-02-2020, 01:57 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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