How Do I Run A Sql Query On My Sql Db?
RSS

How Do I Run A Sql Query On My Sql Db?

Category: FAQ   Time: 2009-10-27   Tags:

I need to add a table to my SQL, I have very limited MySQL knowledge.
I’m not sure how to create a table, but I have all the information I need to put in the table.
I use GoDaddy and they use phpMyAdmin 2.9.1.1
Can anyone give me some step by step instructions, I don’t want to drop my database. I need to do this correctly the first time.
Thank you,
A Nervous Novice

Next: Different Price For Domain Name When Using Different Browsers?
Previous: What Is The Best Domain To Buy?
"How Do I Run A Sql Query On My Sql Db?" was posted on Tuesday, October 27th, 2009 at 3:38 pm.

One Response to “How Do I Run A Sql Query On My Sql Db?”
  1. dave_h4(2009-10-27):

    Don’t be nervous!
    Within phpMyAdmin is a link at the top that says SQL.
    Once you have determined the number of columns you need and the data type they require, just type and run the create table command in the SQL window :
    create table name_of_table (
    fisrt_name varchar(200),
    last_name varchar(200),
    registration_date timestamp,
    fk_name_of_table_id integer
    );
    use the fk_name_of_table_id integer if this new table is a child. And be sure to alter the table if you want to do cascading deletions.
    If this is the parent table, then you should have a column for the index.
    It’s easy, and you will not break anything!
    If you are worried, just export your current database using the data and structure method within phpmyAdmin, and save the file locally.

Leave a Reply

 
Recent Posts
Random Posts