Create new database table when user signs up for game items

Question

I would like to know a way to create a copy of a template database for each user when they register. Basically I have an items template database and when a user registers online, a table will be created like userItems that is a direct copy of the items table. I need to be able to do this in php or any way that can be done using a php register page. I was attempting to use CREATE TABLE x LIKE y command but for some reason this doesn't work, and it seems ineffective to then loop through y and put the contents into x. Thanks in advance for any advice.

Are you certain that this problem cannot be solved by creating a new record in a kind of meta-table? Creating a table per user that signs up is a lot of overhead. — StockB, Dec 09 '16 at 16:56

score 2 · Accepted Answer · edited May 23 '17 at 11:45

2

That seems to be the same problem like the author of this question had: Duplicating a MySQL table, indexes and data

(I'm missing the necessary reputation otherwise I would have commented the question)

edited May 23 '17 at 11:45

Community

1
1

answered Nov 03 '15 at 23:46

xourscode

74
4

1

You're correct, just couldn't find it when I was searching. Thank you very much. – user2984232 Nov 03 '15 at 23:47

Create new database table when user signs up for game items

1 Answers1