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…
Tag: MySQL
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…
PHP Tutorials Compilation
PHP Tutorials Compilation Here are the list of our PHP Lessons and Tutorials Introduction to PHP scripting language PHP Tutorial – Learning the PHP Syntax PHP Tutorial – PHP Basic Data types PHP Variables PHP String Variable PHP if statement…
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…
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…
PHP-MySQL Lesson: Select Database
Select Database After we have establish the connection in MySQL server, we have to select a database. To do that we are going to use the mysql_select_db() function. Syntax: mysql_select_db(databasename,connection) Parameter: databasename – the database name you want to use.…
How to Install Modules in Drupal
Installing Modules in Drupal In this lesson we are going to learn how to install a Module to add functionality in our Drupal site. Modules in Drupal can provide a wide range of additional functionality to your site. You can…