What is the Difference between GROUP and ORDER BY

What is the Difference between GROUP and ORDER BY The GROUP and ORDER BY clauses are both used to organize data. But if we are talking about the difference between GROUP and ORDER BY clauses. So we can say : The ORDER BY clause’s use to sort the query result by specific columns. The GROUP […]

How to use of limit clause in mysql with php script

How to use of limit clause in mysql with php script We can retrieve limited rows from the mysql table using the LIMIT clause. I can be used in pagination where are forced to show only limited records like 10, 20, 30, 40 etc. You can use syntax of LIMIT into PHP function mysql_query().This function […]

SQL ORDER BY Clause

We have already seen SQL SELECT command to fetch data from MySQL table. When you select rows, the MySQL server is free to return them in any order, If you want result in sort form you can sort a result set by adding an ORDER BY clause that names the column or columns you want […]

SQL AND condition

The SQL AND condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL AND condition requires that both of conditions should be true. Let’s see the syntax of AND condition in select […]

SQL OR condition

The SQL OR condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL OR condition requires that one of them conditions should be true. Let’s see the syntax of OR condition in […]

MySQL WHERE Clause

MySQL WHERE Clause We have seen SQL SELECT command to fetch data from MySQL table, UPDATE command for update data into mysql table, DELETE data from mysql table. We can use a conditional clause called WHERE clause to filter out results. Using WHERE clause, we can specify a selection criteria to select required records from […]

Difference between DROP and TRUNCATE statement

Difference between DROP and TRUNCATE statement When you use the drop statement it deletes the table’s row together with the table’s definition so all the relationships of that table with other tables will no longer be valid. When you drop a table: 1. Table structure will be dropped 2. Relationship will be dropped 3. Integrity […]

Difference between delete and truncate statements

Difference between delete and truncate statements There is a slight difference b/w delete and truncate statement. The DELETE statement only deletes the rows from the table based on the condition defined by WHERE clause or delete all the rows from the table when condition is not specified. But it does not free the space containing […]

How to copy a sql table into another sql table

How to copy a sql table into another sql table If you want to copy a SQL table into another table in the same SQL server database, it is possible by using the sql select statement. The syntax of copying table from one to another is given below. Select * into from The Example of […]

PHPKIDA Offering Free Tools:

INSTA DOWNLOADER

Download Instagram Videos & Photos.

Download Now

CURRENCY CONVERTER

Real Time Currency Converter

Convert Now

ROBOST.TXT GEN.

Robots.txt File Creater

Create Now

HTML MINIFIER

Compress yout HTML Code

Minify Now

CSS MINIFIER

Compress yout CSS Code

Minify Now

JAVASCRIPT MINIFIER

Compress yout JavaScript Code

Minify Now

Sign up for weekly update

Milkshake is almost ready. If you're interested in testing it out, then sign up below to get exclusive access.