Introduction to MySQL database and its ODBC interface (1) (reproduced)

mysql|odbc| Data | Database sender: Engineer (Jean ~ still have to go, sigh ...), letter area: Linux
Title: Introduction to MySQL Database and its ODBC interface (1) (reprint)
Letter station: BBS Water Wood Tsinghua Station (Mon Aug 9 18:03:16 1999)

The following text is reproduced from the Database discussion area.
"The original was published by engineer."
Introduction to MySQL database and its ODBC interface

Engineer 1999.8.8

The first part MySQL

A. mysql Introduction
MySQL is a database based on SQL language and is popular in the world. The main goal of MySQL
is speed and robustness. MySQL is based on a set of high requirements in the production environment for many years of operation
Routines. MySQL is still evolving.

Two. The main features of MySQL
1. Full multi-threading, suitable for multi-CPU use.

2. Provide the API interface of C,c++,java (JDBC), perl,python,php and TCL. @_@

3. Multi-platform, including Solaris,sunos,,bsdi,sgi Irix,aix,dec Unix,linux,freebsd,
SCO Openserver,netbsd,openbsd,hpux,win9x and NT. (Various platforms support a different function
The same). ^_^

4. Diverse data types, including/unsigned 1,2,3,4,8 byte Integers,float,double,char,
Varchar,text,blob,date,datetime,year,set,enum. *_~

5. Very flexible and secure access system, password encryption. Grin

6. Provides an ODBC interface for WIN95, which can be associated with it through access. A third party developer offers a variety of
An ODBC driver. Sigh

7. Can handle large data (more than 50 million records), the table size is limited to the OS file size: Linux 2G,
The Solaris 2.5.1 is 4g,solaris 2.6 1000G. Faint

8. The authoritative commercial memory leaks software detects no memory leaks. ?!

9. Fully support the Iso8859_1 (Latin1) standard. Do

10. Multiple language Support (no Chinese). :-(

Three. mysql installation.

Because the version of MySQL on the network is not many, the most current is the 3.21.32a version. Take this as an example to illustrate.
Other versions of MySQL may be slightly different in configuration methods.

1. Get from ftp://166.111.68.178/linux/database/or other websites
mysql-3.21.32a-rh50.1.i386.rpm
2. Execute RPM-IVH mysql-3.21.32a-rh50.1.i386.rpm as root
, the Bin,lib,share is installed by default, and the database is stored in the/var/lib/mysql directory.
You can use Rpm-q mysql-l queries.

The following can start MySQL.

Four. mysql Application

MySQL SQL explanation shell
MYSQLSHOW Database Structure Query
Mysqlaccess User Rights Query
Mysqladmin Super User Management tool
Mysqldump Dump Tool
ISAMCHK inspection, optimization, patching data tools

Mysqlimport input database from TXT file
mysql_install_db System Database Setup Script
MYSQLD Daemon Process
Safe_mysqld startup script