MySQL vs SQL?

[Mari]

Can someone tell me the difference between the two?

(I hate asking newbie questions http://www.aota.net/ubb/wink.gif)

Mari

[meikel]

Hi,

SQL means
Structured Query Language
and is a "simple" (maybe) language to get some data out of a database (or into it).
It is being regarded as a standard and most programs that rely on a database, use SQL to read the data.

MySQL is something different. It is a database program for Linux (don't know if it's available for other systems). Of course it supports SQL to get data out of the database and so that's where the name comes from. There are other database programs out there following the same naming scheme
SQL Server (Microsoft)
SQLBase (centure)
Others try to brand their names and not use SQL in their names like
Oracle
DB2 (IBM)
Access (Microsoft)

I give you one example of an SQL query:

SELECT NAME FROM CUSTOMER

That would give all names stored in the database in the table "Customer". It could return a list like
Weber
Gillespie
Smith
if you'd have 3 customers with these names.

In the end, you need a software called MySQL to read that statement and return these names to you.

Greetings from Bonn, Germany
[nbsp][nbsp]Meikel Weber
http://www.meikel.com

[Mari]

Thanks Meikel! You've been very helpful!

Mari

[outline]

I am in a position whereas I don't know wether to utilize MySQL or an Oracle database for a client's project.[nbsp][nbsp]The project would consist of several databases of possibly 400,000 user records containing several fields each.[nbsp][nbsp]I have used MySQL for several projects and never have used Oracle.[nbsp][nbsp]Will MySQL be suitable for this?[nbsp][nbsp]If not, is it a big task ahead of me to learn Oracle?

Many thanks!
------------------

[Deb]

Continued @ http://www.aota.net/ubb/Forum15/HTML/000232-1.html