MySQL? When should I use it and why?

by Michael Hutchings 9 replies
Hey Warriors, I only just signed up and looking forward to learning from you guys and maybe sharing what little I know in return.

I'm trying to get my head around MySQL at the moment, but all the tech talk about it doesn't make too much sense to me.

Can anyone convert MySQL tech into MySQL plain and simple?

Like when should I use it and why?
#main internet marketing discussion forum #mysql
Avatar of Unregistered
  • Profile picture of the author zeurois
    MySQL (or any other databse system) was basically designed to handle large amounts of data. You should use it whenever it could take your work time from one hour at least down to one second.

    It's up to you

    More: It's a service with users and passwords. Each user with its own databases, tables and data. It has lots of commands, from simple ones to very complicate ones. Now... I can tell you more, but I don't know what direction to head to .. I have a lot of stuff about mysql in my head and I don't know what to start with.

    What's your biggest dilemma?
    {{ DiscussionBoard.errors[136146].message }}
  • Profile picture of the author Mark Brian
    Simply put, you use it to store/retrieve data in an organized way.

    {{ DiscussionBoard.errors[136160].message }}
  • Profile picture of the author zeurois
    You could be organized in notepad too
    {{ DiscussionBoard.errors[136166].message }}
    • Profile picture of the author NeelsTheron
      I can't give you a lesson, but I use it every day as most of my sites are Wordpress based, and are connected to a MySQL database, so MySQL is what makes me and my family eat....
      {{ DiscussionBoard.errors[136188].message }}
  • Profile picture of the author dvduval
    You can think of mySQL similar to a spreadsheet. And as a matter of fact, you can export mySQL data to a spreadsheet. All sorts of web applications, including this forum, use mySQL to store data.
    It is okay to contact me! I have been developing software since 1999, creating many popular products like phpLD.
    {{ DiscussionBoard.errors[136177].message }}
  • Profile picture of the author Steven Fullman
    Originally Posted by Michael Hutchings View Post

    Can anyone convert MySQL tech into MySQL plain and simple?

    Like when should I use it and why?
    Hi Michael,

    It would help to know what you're up to, or what your plans are.

    That would make your questions much easier to answer.

    A few examples of when to use a database...

    -> To store visitor/logon information
    -> To handle inventory
    -> Keep track of sales data
    -> For blogging, image libraries, calendering, and lots more.

    Just for the record, SQL is one of the easiest languages to get your head around as a newbie.

    It's extremely high level (meaning very close to written English commands)

    For instance, let's say you have a sales database...

    And in that database, you have a table of customers.

    What if you wanted to find all of your customers whose first name was Fred? could write a statement (or query) that went something like this:

    select * from customers where firstname = 'fred'

    In other words, you ask your database to give you every column entry (*) from your 'Customers' table where 'Fred' turns up in the Firstname column.

    In fact, I think my explanation is harder to understand than the query itself!

    SQL is very newbie friendly, but highly complex and powerful for experts.


    Not promoting right now

    {{ DiscussionBoard.errors[136341].message }}
    • Profile picture of the author clogmoney
      The above answer was brilliant. Couldn't of done better myself. So I won't try.
      {{ DiscussionBoard.errors[136356].message }}
      • Profile picture of the author Neil Morgan
        It's worth saying that you don't often use MySQL directly.

        Scripts such as shopping carts, autoresponders, link trackers, ad trackers etc use it in the background to store their data.

        And those scripts give you ways of interacting with your data without you having to deal with MySQL direct.

        That said, if for any reason you do need to deal with it direct, most hosts give you a tool to do so. PHPMyAdmin is the most common of those tools.



        Easy email marketing automation without moving your lists.

        {{ DiscussionBoard.errors[136378].message }}
  • Profile picture of the author Johnny
    Hi Michael Hutchings

    I don't think you need to know how MySQL works for your online business. Save that for the techie.

    In simple terms, MySQL is a software that allow you to store data. It provide function that allow developer to search for the data (information) that are stored. If you wish, you can think of it like Excel. One worksheet in Excel is One table in MySQL. But in Excel, it is very difficult to link multiple related worksheets together to provide you with the information that you need. In MySQL, it will be much easier.

    MySQL is not the only database that is available. But it is open source, so it is free, or almost free compare to others. Because of this reason, a lot of web application (or even organisation) start to use it.

    Web application required database (for this case MYSQL) to store information
    like customers, products, orders, etc.

    For your question: when should I use it and why?
    Most likely you will not used it directly, but the application that you used will (eg Wordpress). You just need to know how to use Wordpress. You do not need to know how Wordpress used MySQL (how Wordpress use MySQL to store you posts, pages information).


    >>> Real Product Reviews <<<

    {{ DiscussionBoard.errors[136395].message }}
Avatar of Unregistered

Trending Topics