PDA

View Full Version : sql



DavidP
06-07-2004, 12:36 PM
okay...online SQL tutorials suck...

i am at work, and i was trying to find one of my friend's phone numbers, but i didnt have it on me...so then i ftp'd into my account at school to see if i had uploaded my .txt file i keep with all my friends' phone numbers to my account, but unfortunately i had not...

so, in the hastle of trying to find my friend's phone number, i decided it would be a good little side thing to do to make a database on my site that i could personally get into in case i didnt have my phone number list on me and get any of my friends phone numbers in case i need to call them. Just a small project to practice with SQL. I am already very proficient with relational algebra and Prolog, so I know what select, project, rename, where, and all those other keywords do. So I downloaded MySQL.

But the problem is, where do I start? How the heck do I initially create the database in the first place?

I have found tutorials all over the net on what different keywords such as select and update do, but i dont NEED to know that stuff. I know all that already. I need to know how an SQL program is structured, what the entry point is, etc. I need to know how to initially create the database so SQL can access it and manipulate it. That is what I need to know. And I cant find any tutorials on the net that talk about that at all.

Anybody know any?

EvBladeRunnervE
06-07-2004, 12:46 PM
have you checked out mysql.org's documentation? It had all I needed to find out about how to start a database.

http://dev.mysql.com/doc/

DavidP
06-07-2004, 01:09 PM
yes i did.

please enlighten me, oh great EvBladeRunnervE

ober
06-07-2004, 01:18 PM
I don't really know if you can setup a database on your website unless you administer it. You'd have to have mysql installed on the server for you and have privelages setup and whatnot. It would then be my suggestion to install phpmyadmin, which you can do as a simple user. SO, seeing as how you are using a university webspace, I don't think you're going to have much luck installing the database on the webspace.

Hence... you're kinda screwed.

DavidP
06-07-2004, 01:49 PM
it is my CS account.

installing mysql on it wouldnt be hard.

setting up the priviledges is possible, i just dont know how to do it...but there are instructions on setting up priviledges somewhere on the CS webpage...just have to find them.

Thantos
06-07-2004, 01:54 PM
well once you install it you log in as root (no password by default) and start setting it up. To create a database you do: create database name;
then use: use name;
then create the tables and such

Might want to read and follow along with http://dev.mysql.com/doc/mysql/en/Tutorial.html

axon
06-07-2004, 03:20 PM
thantos, what a weak post. You deserve a nice dose of negative rep for not being on AIM, when I know you're home:mad: . My bot wants to talk to you damnit!!! :mad:

Thantos
06-07-2004, 04:27 PM
Who said I was at home?

ober
06-07-2004, 04:39 PM
As I said before, you may want to consider installing phpmyadmin. It would make the setup of the database MUCH easier.

And I didn't know you had access to the server itself. Oh what we have to assume. :rolleyes:

Thantos
06-07-2004, 04:54 PM
Bah! Command line all the way :)