mysql concat columns string alias sql example

mysql concat columns string alias sql example - concatenating more than one columns to a single column and rename by sql alias

Before running this example please make a database hr which can be found: click here to garb the script

mysql-concat-columns-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 columns string alias sql example - concatenating more than one columns to a single column and rename by sql 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 columns string alias sql example - concatenating more than one columns to a single column and rename by sql alias">
  <meta name="keywords" content="php, example, code, table, sql command, sql,mysql concat function, mysql concat function columns string alias">
  <meta name="description" content="mysql concat columns string alias sql example - concatenating more than one columns to a single column and rename by sql alias">
  <style>
   h2, h4{background:#eeD; color:#000083;}
   h2{ padding:3px; margin:3px; font-size:21px;}
   h4{ padding:2px; margin:2px; font-size:12px;}
   p{padding:2px; margin:2px; color:#0099Fd;}
   body{ background:#FFFFFE;}
  </style>
 </head>
 <body>
  <h2>mysql concat columns string alias sql example - concatenating more than one columns to a single column and rename by sql alias</h2>
  <pre>
   
   <?php
    /*
     --------------------------------------------------------------------------------------------
     we have a table named EMPLOYEES in the HR database and we would like to greet all employees
     by concatenating FirstName, LastName columns along with literal character string
     using mysql concat() function with sql alias
     --------------------------------------------------------------------------------------------
    */
    $sql = "
     SELECT concat('Dear ', FirstName, ' ', LastName, ', hope you are well.') AS GreetingEmployee
     FROM employees
    ";
    /*
     ----------------------------------------------------------------------------------
     Note : CONCAT() function returns NULL if any of the given argument(s) is NULL.
     
     ALSO 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 columns string alias sql example - concatenating more than one columns to a single column and rename by sql alias - output in the client

No comments:

Post a Comment

leave your comments here..