|
A database software is a type of computer program that is designed to
handle lots of data, but to store them in such a way
that finding (and thus retrieving) any snippet of data is more efficient
than it would have been if you simply dumped them
willy nilly all over the place. With such database software, if you
(say) keep a list of customers and their shipping addresses,
entering and retrieving information about your one millionth customer
will not take much longer (if at all) than entering and retrieving
information about your 1st customer.
Database programs have many different methods for storing and retrieving data, as well as for organising the stored data on
the computer. One popular way for accessing data, both to store and to retrieve it, is to use a computer language called
"SQL" (often pronounced as "sequel"). SQL was specially designed for database access.
There are many databases that support the use of
SQL to access their data, among them MySQL and PostgreSQL. In other words, MySQL is just a type of database, one of many. The
same goes for PostgreSQL. These two databases are commonly used by programs that run on websites.if you are a programmer, intending to write a computer program that actually accesses MySQL or some other SQL
database, then you will need to learn SQL (as well as a programming language).
Introduction to Databases
Getting a MySQL Server
Creating a Database
SHOW and SELECT
|
|
MySQL is the world's most popular open source database software, with
over 100 million copies of its software downloaded or distributed
throughout it's history. With its superior speed, reliability, and ease
of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS,
ISV, Telecom companies and forward-thinking corporate IT Managers
because it eliminates the major problems associated with downtime,
maintenance and administration for modern, online applications.
Many of the world's largest and fastest-growing organizations use
MySQL to save time and money powering their high-volume Web sites,
critical business systems, and packaged software — including industry
leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube,
Wikipedia, and Booking.com.
The flagship MySQL offering is MySQL Enterprise, a comprehensive set
of production-tested software, proactive monitoring tools, and premium
support services available in an affordable annual subscription.
MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl /
Python), the fast-growing open source enterprise software stack. More
and more companies are using LAMP as an alternative to expensive
proprietary software stacks because of its lower cost and freedom from
platform lock-in. |
