Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

aaron4osu

macrumors newbie
Original poster
Sep 1, 2009
15
0
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.
 
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.
 
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.