Blog Details

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>select data from a database.</strong></span></li>
	<li><span style="font-size: 13px;">The <strong>result</strong> is stored in a <strong>result table</strong>, called the result-set.</span></li>
</ul>
&nbsp;
<h2> Syntax :</h2>
SELECT <em>column_name</em>,<em>column_name</em>
FROM <em>table_name</em>;

&nbsp;
<h2><strong>Example :</strong></h2>
SELECT * FROM <em>table_name</em>;

&nbsp;
<h2>SELECT Column Example :</h2>
SELECT CustomerName,City FROM Customers;
                                    


Categories

Php mysql

Latest posts

13.05.14
Implementing CRUD Operations ¶

<ul> <li>Now comes the fun part. We would like t

13.05.14
View

<ol> <li><a href="http://www.yiiframework.com/do

13.05.14
Creating Model

<ol> <li><a href="http://www.yiiframework.com/do

Get Free Quote