comgt
cee oh em gee tee - "commgitt"
Login to access.
User: pw: ?

SQL

SQL - Structured Query Language

Cross-platform language for management of data in relational database management systems (RDBMS). A simple example:

SELECT * 
FROM books
WHERE price > 100.00
ORDER BY title;

A slightly more advanced example, showing use of SQL and PHP embedded in HTML:

<?php

// step 1 of 3 - connect to server
$dbcnx = @mysql_connect("databasehost", "username", "password");
if (!$dbcnx) {
  echo( "<P>Unable to connect to the database server at this time.</P>" );
  exit();
}

// step 2 of 3 - select database
if (! @mysql_select_db( "databasename" ) ) {
  echo( "<P>Unable to locate the 'databasename' database at this time.</P>" );
  exit();
}

// step 3 of 3 - do some processing w/ database, e.g. run query
$sql = 'SELECT * FROM `PCBs` LIMIT 0, 30 ';
$result = mysql_query( $sql, $dbcnx );
if (!$result) {
  echo( "<P>Error performing query: " . mysql_error() . "</P>" );
  exit();
}

// parse and process results from query
while ( $row = mysql_fetch_array($result) ) {
  echo( "<p>" . $row["NameKey"] . "</p>" );
}

?>

Database Products

That supports SQL

References

 

Updated 2008-08-27