SQL database setup?
What are the best practice for setting up databases with SQL
do i really need to use the DOS prompt, or can i just write them out with windows note pad. then copy and paste it all into phpmyadmin.
- Anonymous1 decade agoFavorite Answer
there is a free to use database creation program available. you can get a copy by searching on www.softpedia.com for sql database.
i forget the name of the program at this time.
- .PANiCLv 51 decade ago
You can manage your entire database from phpMyAdmin. It's the best software in my mind available for managing MySQL databases.
- 1 decade ago
When setting up a database, i write out every attribute i'm possibly going to use. then i start normalizing. First remove all the redundant data (first normal form)... 1nF... actually read this:
Once you know what tables and relations you want then just create the SQL statements to create all of that.