[Gllug] Thanx - Databases - NOT Linux specific

[Paul Brazier]

I agree, Access isn't really suitable for learning SQL.

The trouble with mySQL is that it is built for speed - for things like
website backends. It doesn't yet have "sub-SELECTs" or subqueries which
you'll need for anything but the simplest queries. You can get round it
using temporary tables but it's not as elegant.

I've not used PostgreSQL but I think it does sub-SELECTs - correct me if
I'm wrong.

-----Original Message-----
From: HJackson at colt-telecom.com 
Sent: 11 July 2001 13:46
To: colt-telecom.com.HJackson; linux.co.uk;.gllug
Subject: RE: [Gllug] Thanx - Databases - NOT Linux specific


> -----Original Message-----
> From: Matthew Bunter [mailto:matthew at marbit.freeserve.co.uk]
> Cheers for the advice, going to install Postgres on Linux and 
> play with Access to learn SQL.

I would not use access to learn SQL. I found that Access bore little
relation to mySQL or Oracle at the command line because it insists on
brackets and all sorts of crap. mySQL has been really easy so far and
the
manual is quite comprehensive with lots of examples. I would like to use
Postgres on my machine instead of mySQL but I have been unable to find a
tutorial on how to get it onto Windows yet so mySQL will do in the mean
time.

Harry.


**********************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


**********************************************************************

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the originator.

This footnote also confirms that this email message has been checked
for the presence of computer viruses.

**********************************************************************

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug