From: Robert Klemme <shortcutter@...>
Date: 2008-07-01T03:07:20+09:00
Subject: Re: Database stuff!

On 30.06.2008 18:27, Justin To wrote:
> I want to use MySQL and SQL in conjunction with Ruby.
> 
> Basically, I'm totally lost with the database stuff. I installed MySQL,
> but have no clue where to go from there.
> 1. Is the database already setup after installing, if not, how do I set
> it up? Also, from what I've read, SQL is a programming language used to
> manipulate a database.

No, definitively not a programming language.  SQL is a declarative 
language that describes sets.

> Where's a good beginner's tutorial for this?

I'd suggest to look for this at www.mysql.com.

> 2. Where do I write SQL? Is there any SQL-specific editor to do this?

Many editors support SQL editing / syntax highlighting.  Chances are 
that your favorite text editor does as well - unless it's notepad. :-)

> I've been working on parsing some .CSV file to capture some basic
> statistics about it. Now, I want to send these statistics into a
> database to store so I can compare multiple .CSV files later on.

Often RDBMS have tools for loading mass data.  I am not familiar with 
mysql but I'm sure you find in the docs.

Searching for "sql tutorial" or "sql introduction" surely will turn up 
useful stuff.

Kind regards

	robert