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?
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!
(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


Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Fetch Oracle DB rows & print it in HTML file with table's col headers in table format tssr_2001 1 307 Sep-04-2020, 01:39 PM
Last Post: ibreeden
  How to create db table with SQLite and SQLAlchemy?? marcello86 1 243 Sep-02-2020, 03:05 PM
Last Post: marcello86
  Outlook Emails & HTML Table in Message Body JoeDainton123 1 133 Sep-02-2020, 05:15 AM
Last Post: buran
  Adding data to a table in SQLite3 djwilson0495 2 256 Aug-15-2020, 02:48 PM
Last Post: djwilson0495
  Creating a table in SQLite3 djwilson0495 2 177 Aug-10-2020, 03:01 PM
Last Post: djwilson0495
  Endless printing of a table djwilson0495 2 164 Aug-10-2020, 01:42 PM
Last Post: djwilson0495
  Python code for exporting table using Selenium gj31980 4 306 Aug-04-2020, 01:29 AM
Last Post: gj31980
  sports Stats > table output loop problems paulfearn100 3 236 Jul-22-2020, 03:21 AM
Last Post: c_rutherford
  How to save CSV file data into the Azure Data Lake Storage Gen2 table? Mangesh121 0 223 Jun-26-2020, 11:59 AM
Last Post: Mangesh121
  Support required to data log in SQL server single table via raspbeery pi rithikvg 8 492 Jun-23-2020, 05:23 PM
Last Post: buran

Forum Jump:

Users browsing this thread: 1 Guest(s)