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.
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
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)