Blog

concate field data using update query in php mysql

<strong>UPDATE tableName SET fieldName = CONCAT(fieldName, 'New Data To Add Here') WHERE ...</strong> <p style="text-align: left;"><em>example :</em></p>      <strong>UPDATE ws_contact SET webpage =

View More

Sql join from the same table

here you need to use alias name.... <code><a href="http://192.168.1.111/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html&amp;token=1f36f3ef1f79485032b484037

View More

Database Configuration

<h3>* Database Configuration :-</h3> &nbsp; <ul> <li>The config file is located at <strong><strong><strong><strong> <samp>application/config/database.php</samp></strong></strong></strong></strong

View More

Group By and Having Clause

<h2><strong>* Group By :-</strong></h2> <ul> <li><strong>Aggregate functions</strong> often need an added <strong>GROUP BY statement</strong>.</li> <li>The GROUP BY statement is <strong>used</str

View More

Types of Joins in MYSQL

<h2><strong>* What is join?</strong></h2> <ul> <li>An SQL <code>JOIN </code>clause is used to <strong>combine rows</strong> from <strong>two or more tables</strong>, based on a common field between

View More

UNION Operator

<h2></h2> <ul> <li><span style="font-size: 13px;">The <strong>UNION operator</strong> is used to <strong>combine</strong> the result-set of<strong> two or more SELECT statements.</strong></span></l

View More

What is SQL?

<h2>* <span style="text-decoration: underline;">What is SQL?</span></h2> <ul> <li>SQL stands for <strong>Structured Query Language</strong></li> <li>SQL lets you <strong>access and manipulate</st

View More

SELECT Statement

<h2>* <span style="text-decoration: underline;">The SQL SELECT Statement :-</span></h2> &nbsp; <ul> <li><span style="font-size: 13px;">The <strong>SELECT</strong> statement is used to <strong>sele

View More

SELECT DISTINCT Statement

<h2>*<span style="text-decoration: underline;"> The SQL SELECT DISTINCT Statement</span></h2> <ul> <li><span style="font-size: 13px;">In a table, a column may contain <strong>many duplicate values;

View More

WHERE Clause

<h2>* <span style="text-decoration: underline;">SQL WHERE Clause :-</span></h2> <ul> <li><span style="font-size: 13px;">The WHERE clause is used to extract only those records that fulfill a specifi

View More

AND & OR Operators

<h1></h1> <h2>*<span style="text-decoration: underline;"> SQL AND &amp; OR Operators :-</span></h2> &nbsp; <ul> <li><span style="font-size: 13px;">The AND &amp; OR operators are used to filter re

View More

SQL Views

<h2>* SQL CREATE VIEW Statement :</h2> <ul> <li>In SQL, a view is a <strong>virtual table</strong> based on the <strong>result-set of an SQL statement.</strong></li> <li>A view contains <strong>r

View More

PRIMARY KEY Constraint

<h2>* <strong>SQL PRIMARY KEY Constraint :-</strong></h2> <ul> <li>The <strong>PRIMARY KEY constraint</strong> <strong>uniquely identifies</strong> each record in a database table.</li> <li>Prima

View More

FOREIGN KEY Constraint

<h2>* SQL FOREIGN KEY Constraint :-</h2> <ul> <li>A FOREIGN KEY in one table <strong>points to a PRIMARY KEY in another table.</strong></li> </ul> <h3><b>MySQL:</b></h3> CREATE TABLE Orders (

View More

how to search specific character or word in a column ?

<h2>* <span style="text-decoration: underline;">SQL LIKE Operator :-</span></h2> <ul> <li>The<strong> LIKE operator</strong> is used in a WHERE clause to <strong>search for a specified pattern</str

View More

how to find average of a numeric column

<h2>* SQL AVG() Function :-</h2> <ul> <li>The AVG()  function returns the<strong> average value</strong> of a numeric column.</li> </ul> &nbsp; <h2> Syntax :</h2> SELECT AVG(column_name) FROM t

View More

how to find max and min value of a numeric column

<h2>* SQL MAX() Function :-</h2> <ul> <li>The MAX() function returns the largest value of the selected column.</li> </ul> <h2>Syntax :</h2> SELECT MAX(column_name) FROM table_name; <h2>Example

View More

how to find date and time ?

<h2>* SQL NOW() Function :-</h2> <ul> <li>The NOW() function returns the current system date and time.</li> </ul> <h2>Syntax :</h2> SELECT NOW() FROM table_name; <h2>Example :</h2> SELECT Prod

View More

how to add-delete-modify columns in an existing table.

<h2>* SQL ALTER TABLE Syntax :-</h2> &nbsp; <h3>1) To add a column in a table, use the following syntax:</h3> ALTER TABLE table_name ADD column_name datatype &nbsp; <h3><strong>2) To delete a

View More

how to find length of the value in a text field.

<h2>* <span style="text-decoration: underline;">The LEN() Function :-</span></h2> <ul> <li><span style="font-size: 13px;">The LEN() function returns the length of the value in a text field.</span><

View More

SQL NOT NULL Constraint

<ul> <li><span style="font-size: 13px;">The <strong>NOT NULL</strong> constraint enforces a <strong>column to NOT accept NULL values.</strong></span></li> <li><span style="font-size: 13px;">The <s

View More

SQL UNIQUE Constraint

<ul> <li><span style="font-size: 13px;">The <strong>UNIQUE</strong> constraint uniquely identifies each <strong>record in a database table.</strong></span></li> <li><span style="font-size: 13px;">

View More

SQL CHECK Constraint

<ul> <li><span style="font-size: 13px;">The CHECK constraint is used to limit the value range that can be placed in a column.</span></li> <li><span style="font-size: 13px;">If you define a CHECK c

View More


    Latest posts

    22.04.14
    SQL CHECK Constraint

    <ul> <li><span style="font-size: 13px;">The CHEC

    22.04.14
    SQL UNIQUE Constraint

    <ul> <li><span style="font-size: 13px;">The <str

    22.04.14
    SQL NOT NULL Constraint

    <ul> <li><span style="font-size: 13px;">The <str

    Get Free Quote