Home / mySQL (page 4)

mySQL

SQL JOINS

Hi all, The SQL joins are used for combine rows from two or more table based on a common field between them.We are discuss this topic today. It fetch data from two or more tables and which is joined to appear as single set of data. Join Keyword is used …

Read More »

Truncate, Drop and Rename a Table- SQL

Hi all, Here I share some useful information in sql queries like truncate command, drop command alter command. These is more helpful in MYSQL operations. For delete complete data from an existing table using TRUNCATE command. And also delete the data inside the table. For delete a table using DROP …

Read More »

Sorting Arrays – PHP

Welcome to all, Today we practise how to sort an array using php. We know this same problem solving using C, CPP or JAVA etc. But here I share how to solve this problem in php. To arrange the elements in an array in numerical order from highest to lowest …

Read More »

AND and OR Operators – SQL

Hi Guys, Today we share our idea related to AND and OR operator with example. The AND and OR operators are the conditional operator in SQL. It is used to filter the data or records based on conditions. The main difference between AND and OR operators are: the AND operator …

Read More »

MYSQL Functions

Hi all, Welcome to MYSQL functions tutorial. MYSQL functions are useful while performing mathematical calculations, string concatenations, sub-strings etc. SQL provides many built in functions to performe these functionality or performing calculations on data. The most commonly used MySQL functions including: Aggregate functions String functions Date time functions control flow …

Read More »

Set Operation in SQL- UNION, UNION ALL, INTERSECT,MINUS operator

Hi Guys, Welcome to sql set operations. SQL support some set of operations to be performed on MYSQL tadabase table. These are used for getting meaningful results from table, based on different conditions. Union MySQL UNION operator to combine two or more SELECT statements into a single result set. UNION …

Read More »

Retrieve the unique rows without using the DISTINCT keyword

Good Morning to all, We know the uses of DISTINCT keyword in SQL. Here I share some usesful information relates to “Retrieve the unique rows without using the DISTINCT keyword.” The DISTINCT keyword is used to return only distinct or different values. In table, the column may contain many duplicate …

Read More »

SUM the table row values from mysql database – PHP

Here I’m going to discuss about, how to add the table row values using php and mysql. This concept is very simple, we can fetch the data from database add/sum the column values. The values are inserted into database and fetch the values from database, and find the sum values …

Read More »

Difference between having clause and group by statement

GROUP BY The group by clause is used for grouping the records of the database table according to our need. Which is an optional part of SELECT statement. SYNTAX SELECT column1, column2 FROM table_name WHERE [ conditions ] GROUP BY column1, column2 ORDER BY column1, column2 The GROUP BY clause …

Read More »
Social Media Auto Publish Powered By : XYZScripts.com