How to give secure name to a Table which is created dynamically and What tree structure has to follow for better search,insert and update of record.

See more:

MySQL

database

hello,

I am creating a project in that i got a problem .I like to generate a table name. i will use this table name to create a table dynamically so i am thinking what parameters i have to consider so that the table name should be Unique and Secure(Means not Hack-able) Where as i don't want to consider Username,E-Mail ID and Password(Means User Personal Details) as parameter.Please Tell me any other way.


In my project 10000+ users are there corresponding to each more than 3 tables are created dynamically so i would like to follow some Tree Structure so that it take less time for Searching,Insert and Update a record.

Is it good to create separate database for each user or not?


Thanks in Advance.