Docstoc

MySQL MySQL MySQL database is the world s

Document Sample
MySQL MySQL MySQL database is the world s Powered By Docstoc
					                                             MySQL
MySQL database is the world's most popular open source database because of its fast performance,
high reliability, ease of use, and dramatic cost savings.
Features & Benefits
Scalability and Flexibility
       Run anything from ...
    Deeply embedded applications with a footprint of just 1MB, or
    Massive data warehouses holding terabytes of information


High Performance
    Table and Index Partitioning
    Ultra-fast load utilities
    Distinctive memory caches
    Full-text indexes, and more


High Availability
    Run high-speed master/slave replication configurations with Row-Based and Hybrid
    Replication
    Specialized Cluster servers offering instant failover


Robust Transactional Support
    Complete ACID (atomic, consistent, isolated, durable) transaction support
    Unlimited row-level locking
    Distributed transaction capability, and
    Multi-version transaction support


Web and Data Warehouse Strengths
    High-performance query engine
    Tremendously fast data insert capability, and
    Strong support for specialized web functions, like fast full text searches
    
Strong Data Protection
    Powerful mechanisms for ensuring only authorized users have access
    SSH and SSL support safe and secure connections
    Powerful data encryption and decryption functions


Comprehensive Application Development
    Support for stored procedures, triggers, functions, views, cursors, ANSI-standard SQL, and
    more
    Plug-in libraries to embed MySQL database support into nearly any application
Management Ease
    Use Event Scheduler automatically schedule common recurring SQL-based tasks to execute
    on the database server
    Average time from software download to complete installation is less than fifteen minutes


Open Source Freedom and 24 x 7 Support
    Around-the-clock support and indemnification available through MySQL Network
    Enterprise quality and enterprise ready, from installation to support


Lowest Total Cost of Ownership
    Save on database licensing costs and hardware expenditures, all while cutting systems
    downtime
Advantages over PostgreSQL:
MySQL Server is generally much faster than PostgreSQL.

MySQL 4.0.1 also has a query cache that can boost up the query speed for mostly-read-only sites
many times.

MySQL Server is used more in production environments than PostgreSQL.

MySQL has more APIs to other languages and is supported by more existing programs than
PostgreSQL.

MySQL Server works on 24/7 heavy-duty systems. In most circumstances you never have to run
any cleanups on MySQL Server.

MySQL Server supports more of the standard ODBC functions than PostgreSQL.

Coding for Inserting a data into the database using PHP
html coding:
<html>

<body>

<form action="din1.php" method="post" >

<pre>Name     :             <input type="text" name="name"></pre>

<pre>Username        :      <input type="text" name="username"></pre>

<pre>Password        :      <input type="password" name="password"></pre>

<pre>address :       <input type="text" name="address"></pre>

<pre>email    :             <input type="text" name="email"></pre>

<input type="submit" value="OK"/>
</form>

</body>

</html>

PHP Coding:
<?php

$con=mysql_connect("localhost","root","");

if(!$con)

{

die('Could not connect:'.mysql_error());

}

mysql_select_db("siva",$con);// here siva is the database name that u have created...//

$sq="INSERT INTO emp (Name, Username, Password, address, email) values
('$_POST[name]','$_POST[username]','$_POST[password]','$_POST[address]','$_POST[email]')";
//here emp is the table name ,that created in the database siva.The table contains four fields r
username,password, address ,email,//
if(!mysql_query($sq,$con))

{

die('Error: ' . mysql_error());

}

echo "1 record added";

mysql_close($con);

?>

				
DOCUMENT INFO
Tags:
Stats:
views:79
posted:5/4/2010
language:English
pages:3
Siva Ramakrishnan M Siva Ramakrishnan M Software
About Hi I'm siva B.E(Computer Science),Graduated in the year 2009.At Present working as a contractor in CTS Bangalore