C Program to Add two numbers Program to add two integer numbers To read the input numbers we are using scanf() function and then we are using printf() function to display the sum of these numbers. The %d used in scanf() and printf() functions is the format specifier which is used for int data types in C programming. … Read more
Introduction PHP started out as a small open source project that evolved as more and more people found out how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in 1994. PHP is a recursive acronym for “PHP: Hypertext Preprocessor”. PHP is a server side scripting language that is embedded in … Read more
How to Write and Run a C Program in Ubuntu Linux is becoming a programming heaven for developers. This is an open source and free operating system. Turbo C compiler is already an old approach to compile programs so let us programmers move to Linux for a new programming environment. Step 1: Install the build-essential … Read more
Free Let’s Encrypt SSL certificates on Centos 6 Let’s Encrypt installation The Let’s Encrypt Client is a fully-featured, extensible client for the Let’s Encrypt CA that can automate the tasks of obtaining certificates and configuring web servers to use them. The installation is simple but in my case on CentOS 6.x I first needed to … Read more
How to add new hard disk in centos Finding the New Hard Drive in CentOS 6 Assuming the drive is visible to the BIOS it should automatically be detected by the operating system. Typically, the disk drives in a system are assigned device names beginning hd or sd followed by a letter to indicate the … Read more
How to Install MySQL 8.0 on CentOS 7 MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database. Step 1: Adding the MySQL Yum Repository 1. We will use the … Read more
MySQL JOINS MySQL JOINS are used with SELECT statement. It is used to retrieve data from multiple tables. It is performed whenever you need to fetch records from two or more tables. There are three types of MySQL joins: MySQL INNER JOIN (“or sometimes called simple join”) MySQL LEFT OUTER JOIN (“or sometimes called LEFT … Read more
MySQL AND Condition The MySQL AND condition is used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query. Syntax: WHERE condition1 AND condition2 … AND condition_n; Parameter explanation: condition1, condition2, … condition_n: Specifies all conditions that must be fulfilled for the records to be selected. MySQL AND Example The following … Read more
MySQL HAVING Clause MySQL HAVING Clause is used with GROUP BY clause. It always returns the rows where condition is TRUE. Syntax: SELECT expression1, expression2, … expression_n, aggregate_function (expression) FROM tables [WHERE conditions] GROUP BY expression1, expression2, … expression_n HAVING condition; Parameters aggregate_function: It specifies any one of the aggregate function such as SUM, COUNT, MIN, MAX, or AVG. expression1, expression2, … expression_n: It specifies the expressions that … Read more
MySQL GROUP BY Clause The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement. You can also use some aggregate functions like COUNT, SUM, MIN, MAX, AVG etc. on the grouped column. Syntax: SELECT expression1, expression2, … expression_n, aggregate_function (expression) … Read more