www.webdeveloper.com
Results 1 to 3 of 3

Thread: MYSQL, SQLite, PHPMyAdmin, SQL: Do they do the same job?

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    MYSQL, SQLite, PHPMyAdmin, SQL: Do they do the same job?

    Hi guys, pretty new to PHP and Databases. just wants to know. I have been using the console (cmd.exe) to make databases and then learnt about MYSQLite and was about to learn and install it, BUT! is it not the same as PHPMyAdmin and MYSQL. just like a text editors (there lots out there but they can give you the same end result). or are they all different and should be used for certain tasks?

    just wanted to know as I would prefer to learn a master one database program than learn many.

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,304
    MySQL is a DBMS (database management system). phpMyAdmin is a PHP web application that provides a web-based front-end to MySQL databases -- it does nothing without MySQL also being installed (along with PHP, of course).

    SQLite is a different DBMS, designed to be light-weight and (relatively) easy to bundle as part of an stand-alone application -- i.e., you don't have to install a stand-alone DBMS application. (You do have to install the necessary drivers/extensions for the programming language you are using it with, in most cases.)
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    MySQL and SQLite both are RDBMS which means they are Relational database management system. They are used to store data and to use those data when need.
    On the other hand phpMyAdmin is application which is based on PHP to administrate the MySQL database. You can do everything with phpMyAdmin like you could it with MySQL commands using the terminal.

    You can get start with MySQL which is a great RDBMS. You can have a look at these tutorials like How to install MySQL , Gui Tools for MySQL

    Best of luck.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles