Jump to content

Archived

This topic is now archived and is closed to further replies.

john6384

SQL newbie needs help

Recommended Posts

Hello, I need to setup a simple sql database in order to test some queries out. What is the simplest way to set one up? I did try a free hosting package and using the phpmyadmin although that was very slow and crap. Is there any cool ways I can do this?

Thanks anyone

Share this post


Link to post
Share on other sites

phpmyadmin is one of the best tools for newbies to start with, although learning to create SQL statements yourself for creating tables is also extremely helpful. i would recomend using phpmyadmin, but using the SQL entry tool and creating simple tables yourself:

 

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]CREATE TABLE testTable(

id int(11) auto_increment PRIMARY KEY,

name varchar(150),

email varchar(150) UNIQUE

);

[!--sql2--][/div][!--sql3--]

 

good luck!

Share this post


Link to post
Share on other sites

Thanks is there not anything else that I can use - i dunno maybe i could upload something? I managed to make a table in phpmyadmin although its slow and i cannot figure out how to enter data into the table. I tried to get a free version of oracle (big file).

Cheers

 

Share this post


Link to post
Share on other sites
Thanks is there not anything else that I can use - i dunno maybe i could upload something? I managed to make a table in phpmyadmin although its slow and i cannot figure out how to enter data into the table. I tried to get a free version of oracle (big file).

Cheers

312543[/snapback]

oracle is a totally separate database, not a tool for mysql.

 

the speed of phpmyadmin is really dependent on two things: your server and your connection speed. if you're not using broadband, it will be slow. there are no other free tools that i know of that are going to run any faster than this for an online tool. you can get some desktop apps that will interface with your mysql databases, but these can be tricky to setup. the speed difference may make up for the difficulty in your case, though. just run a google search on mysql tools and see what you can come up with.

Share this post


Link to post
Share on other sites

I had a look on google but did not have much luck. I dont realy know what im looking for. Maybe you could give me a better idea of what im looking for. I just need to write a simple database and then do queries on it- i wish it was as simple as access.

cheers

 

Share this post


Link to post
Share on other sites

Go to the downloads section at mysql.com and get the Administrator and Query tools - for free.

Share this post


Link to post
Share on other sites

That helps, although when I use the mysql admin I get an error 1130 telling me I cannot connect to the database. Ill try a different hosting. Do only some hostings work - does anyone know any?

Thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.