phpMyAdmin is a free software tool written in PHP, it is a browser-based platform used to manage and administer MySQL database. On the previous tutorial we have learned how to create a backup of our databases using the mysqldump command.…
Tag: MySQL Tutorial
Backup MySQL database on WAMP
Backup MySQL database on WAMP In this tutorial we are going to learn how to back up our MySQL database in WAMP using the mysqldump command. mysqldump command is used to export a database or all databases that resides on…
MySQL ALTER Command
In this lesson we are going to learn how to use the MySQL alter command. There are lots of Graphical User Interface (GUI) Tools to manage our MySQL databases as discussed on this page (link), through that modifying the structure…
MySQL SHOW Command
MySQL SHOW Command SHOW command is used to learn more about the databases found in the server, tables found in a database, and specific information about the columns or fields within a table. Let’s take a look on the uses…
Drop Database and Table in MySQL
Dropping the Database To delete an entire database, use the DROP DATABASE command. This command will delete the database and the tables inside it. Let’s try some example: Syntax of DROP DATABASE command: DROP DATABASE database_name; Where: database_name is the…
Graphical Tools to interact with MySQL
Graphical Tools to interact with MySQL If you’re tired of using the traditional mysql built-in command line tool then this article is just for you. We’ve prepared a list of Graphical Tools used to manage our MySQL databases. First things…
MySQL Database Activity 2
MySQL Database Activity 2 This activity will test your knowledge on basic sql statements. To review our MySQL Lessons and Tutorials, kindly visit this link MySQL Tutorials Compilation. The answers can be found on our facebook page or you can download the answers here. 1.…
MySQL Tutorials Compilation
MySQL Tutorials Compilation Here are the list of our MySQL Lessons and Tutorials Introduction to MySQL Database MySQL Tutorial – Creating a database in MySQL MySQL Tutorial – Creating a Table in MySQL MySQL Tutorial – INSERT INTO Command MySQL…
MySQL Tutorial – Using BETWEEN condition
Using BETWEEN condition BETWEEN condition is used to retrieve records with in the given range. The syntax of BETWEEN condition: SELECT column_name(s) FROM table_name Where column_name BETWEEN value1 AND value2;
MySQL Tutorial – Using HAVING clause
Using HAVING clause HAVING clause is somewhat similar to WHERE clause and it is used together with the GROUP BY clause. It was added to SQL to combine with the aggregate functions because the WHERE clause doesn’t allow aggregates. The…