MySQL installation and application [sequence]

MySQL
Is a small relational database management system developed by Sweden
Mysqlab
Company, in
2008
Year
1
Month
16
ID
Sun
Acquired by the company. Currently
MySQL
And
Sun
Together
Oracle
Acquisition (of course, due to EU intervention,
Oracle
May be considering how to handle it
MySQL
).

MySQL
Features

1.



Use
C
And
C ++
Write, and use a variety of compilers for testing to ensure the portability of source code

2.



Supported
AIX
,
FreeBSD
,
HP-UX
,
Linux
,
Mac OS
,
Novell NetWare
,
OpenBSD
,
OS/2 wrap
,
Solaris
,
Windows
And other operating systems

3.



Provides
API
. These programming languages include
C
,
C ++
,
Eiffel
,
Java
,
Perl
,
PHP
,
Python
,
Ruby
And
TCL
And so on

4.



Supports multiple threads and makes full use of them.
CPU
Resources

5.



Provides transactional and non-transactional storage engines

6.



Optimized
SQL
Query Algorithm to effectively improve the query speed

7.



It can be used as a separate application in the network environment of the client server, and can also be embedded into other software as a library to provide multi-language support, common encoding such as Chinese
GB 2312
,
Big5
, In Japanese
Shift_jis
Can be used as the data table name and data column name.

8.



Provide
TCP/IP
,
ODBC
And
JDBC
And other Database Connection Methods

9.



Provides management tools for managing, checking, and optimizing database operations.

10.



It can process large databases with tens of millions of records

Because
MySQL
It has the basic functions of the database and the above advantages.
MySQL
Small Scale, limited functions, and other constraints, but due to its open-source characteristics
MySQL
It has been widely used, especially for some websites (especially completely free of charge ).
Lamp
And the application of small and medium-sized enterprises.

Currently (
2009
Year
12
Month
12
Day
) Released
MySQL
The official version of is
5.1.41
, You can
Official MySQL website



Or
MySQL Chinese Network



Download the latest
MySQL
Server. Determine the operating system type of the server before downloading to select an appropriate
MySQL
Installation files. This document only describes
Windows
Platform and
Linux
Under the Platform
MySQL
Installation and related connection and configuration operations.