Bottom Page

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!
Quote
#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
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to compare in python an input value with an hashed value in mysql table? Formationgrowthhacking 4 164 Jan-14-2020, 11:43 AM
Last Post: Formationgrowthhacking
  Convert XML into DB table Rohit 3 209 Jan-14-2020, 04:44 AM
Last Post: Rohit
  Need help with For Loop logic for reading docx Table column data vintysaw 2 335 Jan-10-2020, 06:36 AM
Last Post: vintysaw
  Join table with differnt datype column using python query abhishek6555 1 86 Jan-07-2020, 11:44 PM
Last Post: micseydel
  Failed to insert record into MySQL table.Python type tuple cannot be converted farah97 3 368 Dec-26-2019, 02:01 PM
Last Post: buran
  HELP: Combine records in a table with missing start or end date Techy_RN 1 142 Dec-16-2019, 08:51 PM
Last Post: Clunk_Head
  Columns in a table Reldaing 7 259 Nov-20-2019, 12:47 PM
Last Post: ThomasL
  Trying to print an uneven list to a even table Mike2607 6 235 Nov-19-2019, 06:14 AM
Last Post: perfringo
  Iterating an attribute table using Arcpy teflon 6 346 Oct-28-2019, 09:15 PM
Last Post: teflon
  How read Table Structure from Database nnsatpute 5 813 Oct-25-2019, 10:08 AM
Last Post: Larz60+

Forum Jump:


Users browsing this thread: 1 Guest(s)