mysql select specific columns using sql command

mysql select specific column(s) using sql command

mysql-select-specific-columns.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 select specific column(s) using sql command</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 select specific column(s) using sql command">
  <meta name="keywords" content="php, example, code, table, sql command, sql, select specific rows of a table">
  <meta name="description" content="mysql select specific column(s) using sql command">
  <style>
   h2, h4{background:#ddd; color:#000090;}
   h2{ padding:3px; margin:3px; font-size:21px;}
   h4{ padding:2px; margin:2px; font-size:18px;}
   p{padding:2px; margin:2px; color:#0099Ff;}
   body{ background:#FFFFFb;}
  </style>
 </head>
 <body>
  <h2>mysql select specific column(s) using sql command</h2>
  <pre>
   <?php
    /*
     --------------------------------------------------------------------------------
     WE WANT TO SELECT DepartmentID and  DepartmentName columns of departments table
     by using sql command
     --------------------------------------------------------------------------------
    */
    $sql = "SELECT DepartmentID, DepartmentName FROM departments";
    /*
     --------------------------------------------------------------------------
     you can filter duplicate rows by using DISTINCT keyword before a column
     --------------------------------------------------------------------------
    */
    $sql = "SELECT DISTINCT DepartmentID, DepartmentName FROM departments";
    /*
     -------------------------------------------
     you can use this in php. just follow this:
     -------------------------------------------
    */
    
    mysql_connect('localhost', 'root', 'root');
    mysql_select_db('hr');
    mysql_query($sql);
    
    /*
     ---------------------------------------------------------
     provide your own data if you have differ than that of me
     ---------------------------------------------------------
    */
   ?>
  </pre>
 </body>
</html>

mysql select specific column(s) using sql command - output in the client - example 1

mysql select specific column(s) using sql command - output in the client - example 2

No comments:

Post a Comment

leave your comments here..