mysql concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias
Before running this example please make a database hr which can be found: click here to garb the script
mysql-concat-function-string-alias-sql-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 concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias</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 concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias">
<meta name="keywords" content="php, example, code, table, sql command, sql,mysql concat function, mysql concat string alias">
<meta name="description" content="mysql concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias">
<style>
h2, h4{background:#eee; color:#000087;}
h2{ padding:3px; margin:3px; font-size:22px;}
h4{ padding:2px; margin:2px; font-size:19px;}
p{padding:2px; margin:2px; color:#0099Fd;}
body{ background:#FFFFFb;}
</style>
</head>
<body>
<h2>mysql concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias</h2>
<pre>
<?php
/*
--------------------------------------------------------------------------------------------------
so we have a table named EMPLOYEES in the HR database and we would like to get the value of
FirstName AND LastName concatenated to a single value using a character string between them
and also rename the heading by using mysql concat function and sql character string and sql alias
--------------------------------------------------------------------------------------------------
*/
$sql = "SELECT concat(FirstName, ' ', LastName) AS FullName FROM employees";
/*
----------------------------------------------------------------------------------
CONCAT() function returns NULL if any of the given argument(s) is NULL.
NOTE(my experience) ABOUT NULL:
1. NULL IS A VALUE THAT IS UNAVAILABLE
2. NULL IS A VALUE THAT IS UNASSIGNED
3. NULL IS A VALUE THAT IS UNKNOWN
4. NULL IS A VALUE THAT IS INAPPLICABLE
5. NULL IS A VALUE THAT IS NOT EVEN EQUAL TO NULL
6. NULL IS A VALUE THAT IS NOT EQUAL TO ZERO : ZERO IS A NUMBER
7. NULL IS A VALUE THAT IS NOT EQUAL TO BLANK SPACE OR EMPTY STRING : SPACE IS A CHARACTER
AND 8. COLUMNS OF ANY DATATYPE CAN CONTAIN NULL VALUE
----------------------------------------------------------------------------------
*/
/*
-------------------------------------------------------
USING PHP YOU CAN DO THIS.
GET CONNECTION TO DATABASE BY USING : mysql_connect()
SELECT DATABASE BY USING : mysql_select_db()
THEN RUN THE QUERY
-------------------------------------------------------
*/
mysql_connect('localhost', 'root', 'root');
mysql_select_db('hr');
mysql_query($sql);
/*
------------------------------------------------------------------------------
TO RUN THE PHP CODE PROVIDE REAL DATA TO mysql_connect AND mysql_select_db()
------------------------------------------------------------------------------
*/
?>
</pre>
</body>
</html>
mysql concat function string alias sql example - concatenating two or more strings to a single and rename heading by alias - output in the client
No comments:
Post a Comment
leave your comments here..