Page 1 of 3 123 LastLast
Results 1 to 15 of 33

Thread: Learning MySQL

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: Learning MySQL

    Hi. I just wondering what is the best book I can buy about MySQL. Also what software do you recommend using to write MySQL code?

    Thank you

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    best book for mysql? no idea, but if you are new to SQL in general, you could try mine

    as for software to write queries, try HeidiSQL

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2010
    Posts
    1
    It's not a specific MySQL book but I would recommend what I consider to be my bible: Fundamentals of Database Systems by Elmasri / Navathe. The new editions are rather pricy, but the earlier editions are still relevant (I've got one from the beginning of the 2000's).

    It goes deep into the best practices of relational databases and also has a good section on SQL that you can implement in MySQL.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    to write queries
    theres also the MySQL query browser from MySQL which comes as part of the MySQL GUI tools downloadable from the MySQL website
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Aug 2010
    Posts
    1
    Does anyone have a good place to see basic variables? I'm looking to do queries and have only been able to find ways to query exact matches. Is there a mway to query data in a field that say begins with PB-? Or is there a way to use wildcards?

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by zephyrsports View Post
    Is there a mway to query data in a field that say begins with PB-? Or is there a way to use wildcards?
    ... WHERE somecolumn LIKE 'PB-%'
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Aug 2010
    Posts
    1

    MySQL Tools

    Can someone suggest tools for working with my database? I have access to PHPMyAdmin, but I find that I need more functionality and when I have a large database, I run into problems with import/export feature.

    Thanks!

  8. #8
    Join Date
    Aug 2010
    Posts
    1
    There are many ebooks and MySql for Dummies as standard. I say just keep on pratice. You won't break anything.

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sanmiguel View Post
    I have access to PHPMyAdmin, but I find that I need more functionality...
    try HeidiSQL

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Aug 2010
    Posts
    1

    Leaning MySQL

    Thanks r937, I just logged onto your site and I'll probably buy your book.

    Cheers again

  11. #11
    Join Date
    Aug 2010
    Posts
    1
    I have to say moving between different projects incorporating different vendors of SQL is really annoying given that each one makes up its own keywords... Why cant they use the same keywords?!

  12. #12
    Join Date
    Aug 2010
    Posts
    1
    I think you can simply get a lot of information about MYSQL via google search.

  13. #13
    Join Date
    Aug 2010
    Location
    South Dakota
    Posts
    1
    Quote Originally Posted by Bezzen View Post
    It's not a specific MySQL book but I would recommend what I consider to be my bible: Fundamentals of Database Systems by Elmasri / Navathe. The new editions are rather pricy, but the earlier editions are still relevant (I've got one from the beginning of the 2000's).

    It goes deep into the best practices of relational databases and also has a good section on SQL that you can implement in MySQL.
    Thanks for this information, I am struggling with MySQL and have been confused as to where to start. I thought I could just jump in but I was sure wrong about that!!

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    did you try the tutorials on the mysql.com site?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Aug 2010
    Posts
    1
    Hi Demis.

    Try MySQL :: MySQL 5.0 Reference Manual :: 3 Tutorial

    Hope this helps.

Posting Permissions

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