Jump to content


Photo

SQL newbie needs help


  • Please log in to reply
6 replies to this topic

#1 john6384

john6384
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 29 October 2005 - 10:51 AM

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

#2 obsidian

obsidian
  • Staff Alumni
  • Advanced Member
  • 3,202 posts
  • LocationSeattle, WA

Posted 29 October 2005 - 12:40 PM

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!
You can't win, you can't lose, you can't break even... you can't even get out of the game.

<?php
while (count($life->getQuestions()) > 0)
{   $life->study(); } ?>
  LINKS: PHP: Manual MySQL: Manual PostgreSQL: Manual (X)HTML: Validate It! CSS: A List Apart | IE bug fixes | Zen Garden | Validate It! JavaScript: Reference Cards RegEx: Everything RegEx

#3 john6384

john6384
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 29 October 2005 - 01:02 PM

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


#4 obsidian

obsidian
  • Staff Alumni
  • Advanced Member
  • 3,202 posts
  • LocationSeattle, WA

Posted 29 October 2005 - 01:12 PM

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

View Post

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.
You can't win, you can't lose, you can't break even... you can't even get out of the game.

<?php
while (count($life->getQuestions()) > 0)
{   $life->study(); } ?>
  LINKS: PHP: Manual MySQL: Manual PostgreSQL: Manual (X)HTML: Validate It! CSS: A List Apart | IE bug fixes | Zen Garden | Validate It! JavaScript: Reference Cards RegEx: Everything RegEx

#5 john6384

john6384
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 29 October 2005 - 02:21 PM

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


#6 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 29 October 2005 - 05:47 PM

Go to the downloads section at mysql.com and get the Administrator and Query tools - for free.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#7 john6384

john6384
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 29 October 2005 - 07:10 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users