[plug] Optimise MySQL query

[Simon Marko]

nigel at dubh.id.au wrote:

>Hi Shannon,
>
>On Wed, Mar 29, 2006 at 11:15:38AM +0800, Shannon Carver wrote:
>
>  
>
>>I've found the best way to learn SQL syntax is work out what you're trying
>>to do, give it a go at solving it, then query here or google or something.
>>    
>>
>
>Thats the way I usually work with most things. However I think in
>this case I am going to have little projects dropped on my lap
>that I will be expected to wrangle into some sort of shape with
>limited time. So I thought I might be better off getting a good
>grounding in the subject. 
>
>Still I think google is always going to be a good friend.
>
>Nigel
>
>
>_______________________________________________
>PLUG discussion list: plug at plug.org.au
>http://www.plug.org.au/mailman/listinfo/plug
>Committee e-mail: committee at plug.linux.org.au
>
>  
>
Hi Nigel,
I have found http://www.sqlcourse.com to be a good introduction to SQL 
in general, introducing concepts one by one with examples.
I'm working with Oracle, MySQL Ingres and very occasionally with SQL 
Server and Sybase - they are all similar in their SQL dialects up to a point
:)

::SimonM::