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

Join 136,310 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,476 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
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
+Quote Post

jjsaw5
RE: Automatically Create Databases
18 Aug, 2008 - 04:13 AM
Post #2

I must break you
Group Icon

Joined: 4 Jan, 2008
Posts: 1,394



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 online!Profile CardPM
+Quote Post

dineeshd
RE: Automatically Create Databases
18 Aug, 2008 - 04:30 AM
Post #3

D.I.C Addict
Group Icon

Joined: 30 Jun, 2008
Posts: 578



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 offlineProfile CardPM
+Quote Post

Will_00
RE: Automatically Create Databases
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
+Quote Post

mocker
RE: Automatically Create Databases
18 Aug, 2008 - 09:16 AM
Post #5

D.I.C Regular
Group Icon

Joined: 14 Oct, 2007
Posts: 258



Thanked: 15 times
Dream Kudos: 25
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
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 06:42AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month