stuck with table name ???

Anon

hi all

I have got a web site on which when a user registers himself a table is created with his userid. everything was working fine but now the problem is, that, if somebody makes id like "hotsexy_male_need_sexyfem" then mysql is unable to create table ??

cant we make a table with name "hotsexy_male_need_sexyfem" ???

is there a problem because of length or "_" sign ??

Any idea ??

Thanx a lot

Tabish

Anon

The only restriction is length for a table name at 64 chars.

I've tried creating a table with your name
(hotsexy....) and have had no problem.

Do you have any more details on the error?

Justin

[deleted]

ouch, very very bad practice!!

what if I enter a name like "/etc/passwd"?

You should not use user-data to create tables.

You whole idea of creating one table per user is wrong, you should have one large table that holds all the user data.

joshsisk

Yeah, why would you want to make a table for each user? That makes no sense whatsoever. What happens if you get 1,000+ users? Your db would be totally unmanagable.

Your tables and columns should be set up and static before any user information is submitted to your site. It's also way more efficient to use one table with many rows than many tables with one row each. It let's you do a lot of interesting stuff with the data, much easier, as well...

Anon

yeah I know it's a BAD Idea and I had also thought about that, what if I want to make a simple mail system for each user.

What I want to do is, I want to make a personal mailbox system for each user. And for that I will have to store each messges for him which is actually sent by other users. How can I store it in to a table if the messages number are undefined ?? the table which I have created is storing the messages,sent date,folder-options and so many other stuffs too.

How can I manage all these stuffs for each user in one table ???

And as far as the name is concerned "etc/passwd" ...no body can use any charecters but alphabets/numbers and "_" ..

Please try to expalain me Vincent .. how can I manage a personal mailbox into one table ??

Thanx a lot..