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.
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.
Comments
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.
good luck.
You can manage your entire database from phpMyAdmin. It's the best software in my mind available for managing MySQL databases.
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:
http://www.trumpetpower.com/Papers/Normal_Forms
Once you know what tables and relations you want then just create the SQL statements to create all of that.
http://www.w3schools.com/sql/sql_create.asp