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
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 237 Jul-02-2021, 02:19 PM
Last Post: xtc14
  scraping a table from an http page vchealy 1 244 Jun-10-2021, 09:48 AM
Last Post: Larz60+
  UPDATE SQLITE TABLE - Copy a fields content to another field. andrewarles 14 743 May-08-2021, 04:58 PM
Last Post: ibreeden
  Need help on extract dynamic table data Dr_Strange 0 561 Apr-30-2021, 07:03 AM
Last Post: Dr_Strange
  Load the data from multiple source files to one table amy83 2 418 Apr-27-2021, 12:33 AM
Last Post: Pedroski55
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 1,821 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  Remove Blank Lines from docx table and paragraphs bsudhirk001 1 616 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 459 Feb-05-2021, 04:37 PM
Last Post: nilamo
  write mariadb table rows query to each file? shams 1 571 Feb-02-2021, 04:10 PM
Last Post: buran
  Convert table in pandas tgottsc1 2 462 Jan-26-2021, 01:58 PM
Last Post: tgottsc1

Forum Jump:

User Panel Messages

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