mysql parentheses in sql command example
mysql-parentheses-in-sql-command-example.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>mysql parentheses in sql command example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Md Iqbal Hosan">
<meta name="title" content="mysql parentheses in sql command example">
<meta name="keywords" content="php, example, code, table, sql command, sql, mysql parentheses">
<meta name="description" content="mysql parentheses in sql command example">
<style>
h2, h4{background:#ccc; color:#000098;}
h2{ padding:3px; margin:3px; font-size:22px;}
h4{ padding:2px; margin:2px; font-size:19px;}
p{padding:2px; margin:2px; color:#0099FF;}
body{ background:#FFFFFC;}
</style>
</head>
<body>
<h2>mysql parentheses in sql command example</h2>
<pre>
<?php
/*
------------------------------------------------------------------------------------
WE WANT TO SELECT LastName, MonthlySalary and annual salary + a bonus of 700 of all
employees of the HR database by using sql command where (annual salary + a bonus of 700)
as AnnualSalary using parentheses
------------------------------------------------------------------------------------
*/
$sql = " SELECT LastName, MonthlySalary, (12*MonthlySalary + 700) AS AnnualSalary FROM employees ";
/*
---------------------------------------------------------------------------------------------
by using AS keyword we can define an alias to rename the column name or column name heading
alias is case sensitive
by using parentheses we can define operator precedence. for example -
if we want to add a commission of 700 for each month then what will be AnnualSalary?
we can use following sql statement to find that :
---------------------------------------------------------------------------------------------
*/
$sql = " SELECT LastName, MonthlySalary, 12*(MonthlySalary + 700) AS AnnualSalary FROM employees ";
?>
</pre>
</body>
</html>
mysql parentheses in sql command example - output in the client - example 1
mysql parentheses in sql command example - output in the client - example 2
No comments:
Post a Comment
leave your comments here..