Welcome to Dream.In.Code
Getting Help is Easy!

Join 132,663 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,186 people online right now. Registration is fast and FREE... Join Now!




Automatically Create Databases

 
Reply to this topicStart new topic

Automatically Create Databases

Will_00
post 17 Aug, 2008 - 07:27 PM
Post #1


D.I.C Head

Group Icon
Joined: 20 Jul, 2008
Posts: 51


My Contributions


Is there anyway to be able to automatically create MySQL databases everytime someone registers an account or similar?
User is offlineProfile CardPM

Go to the top of the page

jjsaw5
post 18 Aug, 2008 - 04:13 AM
Post #2


I vill break you

Group Icon
Joined: 4 Jan, 2008
Posts: 1,364



Thanked 6 times

Dream Kudos: 125

Expert In: HTML, CSS, Database,

My Contributions


Why would you want to create a new database every time some one registers?

Why not just insert a new row for each person. Creating a new database everytime some one new comes all is silly. Just insert a new row of information for the new person.
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 18 Aug, 2008 - 04:30 AM
Post #3


D.I.C Addict

Group Icon
Joined: 30 Jun, 2008
Posts: 561



Thanked 16 times

Dream Kudos: 575
My Contributions


Or to the maximum, try to create new tables for each user, of course that too is silly.
User is online!Profile CardPM

Go to the top of the page

Will_00
post 18 Aug, 2008 - 06:43 AM
Post #4


D.I.C Head

Group Icon
Joined: 20 Jul, 2008
Posts: 51


My Contributions


Excuse me, I meant tables for each user.
User is offlineProfile CardPM

Go to the top of the page

mocker
post 18 Aug, 2008 - 09:16 AM
Post #5


D.I.C Regular

Group Icon
Joined: 14 Oct, 2007
Posts: 256



Thanked 15 times
My Contributions


Just have your registration script connect to your database and run a CREATE TABLE command.

If you are creating a new table to hold each users information, you are not designing a very efficient database. There aren't many reasons I can think of for creating a new table, instead of just having a table with user info and inserting a new record there.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 05:42AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month