help setting up very simple database

Discussion in 'Mac Programming' started by aaron4osu, Apr 16, 2011.

  1. macrumors newbie

    Joined:
    Sep 1, 2009
    #1
    I'm trying to learn SQL and want to set up a very simple database on my computer to run SQL statements(create tables, run queries, etc..). I've downloaded querious, razorSQL, but can figure out how to set them up. Hostname, port, etc...

    Isn't there a simple environment to do something like this. I've tried several tutorials on setting up mysql from the terminal but never got that to work either.
     
  2. macrumors 603

    Joined:
    Aug 9, 2009
    #2
    Be specific.

    Exactly which tutorials? Post the URLs.

    Exactly where did you encounter a problem in the tutorial? Post the specific command that didn't work.


    I did a simple google search for razorSQL. Found this page:
    http://www.razorsql.com/articles/sqlite_mac.html

    I have to say, I'm skeptical of razorSQL's quality. There are two blatant errors on this fairly simple page:
    1. The command is misspelled as: sqilte3
    2. Control-Z in Mac OS X Terminal is not EOF, control-D is.
    Control-Z means something completely different.
     
  3. macrumors 6502

    Joined:
    Mar 8, 2004
    #3
    The way I taught myself SQL was by creating simple C++ apps that manipulated data and using this site as a reference.
     
  4. macrumors 6502a

    Joined:
    Apr 1, 2007
    #4
    Do you have a server to connect to? These are clients. I recommend going with MAMP and MysqlWorkbench as they are the most beginner friendly ones I can think of.
     
  5. macrumors 6502

    Joined:
    Feb 7, 2008
    #5
    This seems to be the fastest way to get going:
    http://www.sqlite.org/quickstart.html

    sqlite3 is installed on OS/X, so you can skip the downloading and setup. Once you understand SQL commands and can make sqlite3 work you can move to a larger client/server SQL if you need to.
     

Share This Page