Thread: sql

  1. #1
    l'Anziano DavidP's Avatar
    Join Date
    Aug 2001
    Location
    Plano, Texas, United States
    Posts
    2,743

    Unhappy sql

    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?
    My Website

    "Circular logic is good because it is."

  2. #2
    'AlHamdulillah
    Join Date
    Feb 2003
    Posts
    790
    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/

  3. #3
    l'Anziano DavidP's Avatar
    Join Date
    Aug 2001
    Location
    Plano, Texas, United States
    Posts
    2,743
    yes i did.

    please enlighten me, oh great EvBladeRunnervE
    My Website

    "Circular logic is good because it is."

  4. #4
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    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.

  5. #5
    l'Anziano DavidP's Avatar
    Join Date
    Aug 2001
    Location
    Plano, Texas, United States
    Posts
    2,743
    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.
    My Website

    "Circular logic is good because it is."

  6. #6
    & the hat of GPL slaying Thantos's Avatar
    Join Date
    Sep 2001
    Posts
    5,681
    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

  7. #7
    Registered User axon's Avatar
    Join Date
    Feb 2003
    Posts
    2,572
    thantos, what a weak post. You deserve a nice dose of negative rep for not being on AIM, when I know you're home . My bot wants to talk to you damnit!!!

    some entropy with that sink? entropysink.com

    there are two cardinal sins from which all others spring: Impatience and Laziness. - franz kafka

  8. #8
    & the hat of GPL slaying Thantos's Avatar
    Join Date
    Sep 2001
    Posts
    5,681
    Who said I was at home?

  9. #9
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    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.

  10. #10
    & the hat of GPL slaying Thantos's Avatar
    Join Date
    Sep 2001
    Posts
    5,681
    Bah! Command line all the way

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. OOP Question DB Access Wrapper Classes
    By digioz in forum C# Programming
    Replies: 2
    Last Post: 09-07-2008, 04:30 PM
  2. Please help create a loop for embedded SQL
    By cjohnman in forum C Programming
    Replies: 4
    Last Post: 04-24-2008, 06:46 AM
  3. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 09:09 AM
  4. Replies: 1
    Last Post: 03-21-2006, 07:52 AM
  5. Problem with embedded SQL in C/C++ (ECPG)
    By NeuralClone in forum C Programming
    Replies: 4
    Last Post: 10-21-2005, 05:16 PM