Results 1 to 10 of 10

Thread: MySQL resources

  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    MySQL resources

    I have been given the onerous task of learning MySQL and have 4 months to do it. I do not see it to be too much of a burden but I am looking for a good set of online tutorials and snippets to assist me. Good old Google has brought up some reasonable finds but I am looking for any recommendations from any MySQL users
    Jerry

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: MySQL resources

    Which version of MySQL (i.e. community, enterprise, etc.)? If you go to MySQL AB :: Developer Zone you'll see documentation links on the right for the various release levels. Also, other interesting links.

    Joe
    Joe

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MySQL resources

    Thanks Joe

    Spot on. That will keep me quiet for a little while <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  4. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: MySQL resources

    You're quite welcome Jerry. I doubt that the 'small' bit of reading there will keep you quiet for any length of time. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Joe
    Joe

  5. #5
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MySQL resources

    Hello Jerry,

    I tried to pick up MySQL about a year and a half ago and, while not difficult, I found it awkward, or that's what I recall. I was used to SQL Server, and I got frustrated by having to use the DOS-like window. I think someone told me there's a nicer GUI out there, but never got round to checking it out.

    All in all, my journey to MySQL lasted some three evenings, when I had to quit it to do something important.

    I come from the actuarial field, but a friend from the computing/programming field insists that MySQL is way "better" than SQL Server (and Access for the case), whatever that means, so when you become more experienced I'd like to know your thoughts.

    Good luck!
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MySQL resources

    Thanks Diegol

    You may see from my profile I am a SQL person more than a MySQL. You may also be aware that I am a sessional lecturer in DB Design primarily using Access as the chosen tool. The University has moved over to open source in a big way as they ( and I tend to agree) that Access 2007 is a step too far and now a power toy.

    Teaching classic SQL was very problematic especially in a college environment and it could take about 1.5 hours setting up students to work on their own area. Personally I think SQL is best taught vocationally and not academically.

    However, the short and tall of it is this is purely a fiscal decision by me as I have to move with the times. Looking at the introductory documentation, it does look a bit cumbersome but I am going to have a play
    Jerry

  7. #7
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MySQL resources

    Is MySQL Essentials of any assistance?

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MySQL resources

    Thank you, don't to just love wiki <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  9. #9
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: MySQL resources

    Jerry, check out MySQL AB :: MySQL GUI Tools Downloads. There's a documentation at MySQL AB :: MySQL Documentation.

    Joe
    Joe

  10. #10
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MySQL resources

    <hr>The University has moved over to open source in a big way as they ( and I tend to agree) that Access 2007 is a step too far and now a power toy.<hr>
    I'm not quite the right person to judge this move, but I agree too.

    Other freeware (not sure if open source) DBMS's I've seen mentioned frequently are SQLite and PostgreSQL. R integrates quite nicely with the former as far as I've read. Of course you're tasked with learning MySQL, but in case you happen to be curious... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •