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
  Python VLookup? Lookup Table? Nu2Python 3 125 Oct-25-2021, 08:47 PM
Last Post: Nu2Python
  pandas pivot table: How to find count for each group in Index and Column JaneTan 0 125 Oct-23-2021, 04:35 AM
Last Post: JaneTan
  Slittping table into Multiple tables by rows drunkenneo 1 206 Oct-06-2021, 03:17 PM
Last Post: snippsat
  mySQL Database error not resolving. cybertooth 2 311 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Display table field on multiple lines, 'wordwrap' 3python 0 243 Aug-06-2021, 08:17 PM
Last Post: 3python
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 469 Jul-02-2021, 02:19 PM
Last Post: xtc14
  scraping a table from an http page vchealy 1 510 Jun-10-2021, 09:48 AM
Last Post: Larz60+
  UPDATE SQLITE TABLE - Copy a fields content to another field. andrewarles 14 1,200 May-08-2021, 04:58 PM
Last Post: ibreeden
  Need help on extract dynamic table data Dr_Strange 0 783 Apr-30-2021, 07:03 AM
Last Post: Dr_Strange
  Load the data from multiple source files to one table amy83 2 787 Apr-27-2021, 12:33 AM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

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