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: Database
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…
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 Database Activity 1
MySQL Database Activity 1 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…
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…
PHP-MySQL Lesson: Insert records
Insert records In this lesson we are going to write a PHP script that inserts a new record in our database through HTML forms. The INSERT INTO statement in sql is used to insert a record in the database. In…
MySQL Tutorial – Using Column Aliases
Column Aliases To rename a column in database table, use the AS keyword it allows you to alias the name to different value. The syntax of AS keyword: SELECT column_name(s)AS alias_name FROM table_name AS keyword example: SELECT f_name AS Firstname…