Trending News
Home / mySQL (page 5)

mySQL

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 »

Get highest or second highest or lowest values from table – MYSQL

Hi Guys, Today I share some useful topic related to MYSQL. The MYSQL is very helpful in our project or queries for different functionality. The MYSQL is most popular Open source management system. Suppose that, you are given the following simple database table called EmployeeDetails table that has two field …

Read More »

Alter a column to be AUTO_INCREMENT – Mysql

Hi friends, Today, I’m trying to modify a table to make it’s primary key column AUTO_INCREMENT after the fact. Here I going to demonstrate how to reset auto-increment value in MYSQL. The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows. First create the table with …

Read More »

SQL- Syntax

All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW. And all the statements end with a semicolon (;). SQL is case insensitive, which means INSERT and insert have same meaning in SQL statements. But MySQL makes difference in table …

Read More »

SQL-Basic

SQL is Structured Query Language, for storing, manipulating and retrieving data stored in relational database.Its a standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language.SQL is just a query language, it …

Read More »

Mysql Remove Duplicate Data or Rows With DISTINCT

How do I remove duplicate data or rows from a MySQL query? If output from a MySQL query contains duplicate data or row and if you would like to remove the same use DISTINCT. DISTINCT combined with ORDER BY needs a temporary table in many cases. Consider following query: mysql> …

Read More »

How To Install WordPress

Hi Friends, Today we discuss one different topic related to WordPress. This article shows how to install wordpress in locally or cpanel with clear picture. STEP 1: Download the WordPress installation package To start the wordpress installation, first you need to download the wordpress package from wordpress official site. Download …

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