Thursday, October 19th, 2017

MySQL

0

MySQL abbreviated as ” My Structured Query Language”

mysql

mysql

“. The program runs as a server providing multi-user access to a number of databases.

Web applications uses MySQL acts as the database component of the LAMP software stack. MySQL is used for data storage and logging of user data used by various high traffic websites includes YouTube, Nokia, Google, Wikipedia, Facebook, Flickr. It is written in C and C++.

MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64 and Microsoft Windows.
MySQL extension overview example

<?php
// Connecting, selecting database
$link = mysql_connect(‘mysql_host’, ‘mysql_user’, ‘mysql_password’)
or die(‘Could not connect: ‘ . mysql_error());
echo ‘Connected successfully’;
mysql_select_db(‘my_database’) or die(‘Could not select database’);

// Performing SQL query
$query = ‘SELECT * FROM my_table’;
$result = mysql_query($query) or die(‘Query failed: ‘ . mysql_error());

// Printing results in HTML
echo “<table>\n”;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo “\t<tr>\n”;
foreach ($line as $col_value) {
echo “\t\t<td>$col_value</td>\n”;
}
echo “\t</tr>\n”;
}
echo “</table>\n”;

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

Features and benefits of MySQL

  • Massive data warehouses holding terabytes of information – Flexibility and Scalability
    Distinctive memory caches, Ultra fast load utilities, Table and Index partitioning – High Performance
    High Speed availability
    Support Multi version transaction
    High performance query engine
    Powerful authorization only access by users – Strong data protection
Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • LinkedIn
  • RSS
  • Technorati
  • Twitter

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Secure Linux Web Hosting