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…
Tag: SQL
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…
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 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…
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…