Home / mySQL (page 6)

mySQL

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 »

DISTINCT Keyword- SQL

Hi all, Welcome to SQL world. The SQL is very useful in programming. The sql queries helps in developers. There are different types of keyword, joins, sub-queries and commands are available. The DISTINCT keyword is used for remove the duplicate values from database table in SELECT query. The SELECT DISTINCT …

Read More »

Create Database with MYSQL and Insert Code in PHP

We are going to discuss about ‘how to create database and how to insert the field values in the database using php form’. This application used into all projects like registration form or insert the values to database operations. Table Of Content Database Creation Table Creation Form Creation and action …

Read More »