Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Help with MySQL

  1. Sep 17, 2009 #1
    hey everyone,

    I'm about to take an introductory course in databases in the fall, but I figured I could start learning about them now. I downloaded & installed MySQL Server 5.1, but I'm not exactly sure what to do at this point. I'll migrate to the bin folder and type in the following:

    Code (Text):
    mysql -u root -p
    This will bring me to some sort of main menu. But anyways, can anyone give me some advice or direct me to a really good tutorial? I've been doing some searching on Google and I've found some stuff. I've learned that you can distinguish between the entity that actually stores data (i.e. storage engine) from the management system (which allows you to manipulate the structure that holds data via commands like SQL commands), but I figured asking on here wouldn't hurt either.


  2. jcsd
  3. Sep 17, 2009 #2


    User Avatar

    Staff: Mentor

  4. Sep 17, 2009 #3
    You can just go to a nearby library and grab some books on MySQL/database management.

    For knowing why you are doing what you will be doing in the course, you should use language you know and make one application that stores information in the db. Maybe you would want to get some books on how to access/update/insert/delete data with your favorite language.

    One application suggestion: A user interface (either command prompt/html) that let you post comments, see all comments posted in the past.
  5. Sep 19, 2009 #4
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook