MySQL
MySQL abbreviated as ” My Structured Query Language”
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
