PDA

View Full Version : help setting up very simple database




aaron4osu
Apr 16, 2011, 12:34 PM
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.



chown33
Apr 16, 2011, 12:54 PM
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.

Mac_Max
Apr 16, 2011, 02:48 PM
The way I taught myself SQL was by creating simple C++ apps that manipulated data and using this site (http://www.1keydata.com/sql/sql-commands.html) as a reference.

Hansr
Apr 16, 2011, 03:24 PM
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.

wlh99
Apr 17, 2011, 11:57 AM
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.