MySQL Tutorials - Herong's Tutorial Examples - Version 4.11, by Dr. Herong Yang

MySQL 4.0 Introduction

This section provides a quick introduction of MySQL 4.0 with a list of main features.

MySQL - An open source database management system developed by MySQL AB, MySQL was started with mSQL with fast low-level (ISAM) routines. So MySQL and mSQL are having almost the same application programming interfaces and command line interfaces.

Main features of MySQL 4.0 (extracted from MySQL manual):

  • Works on many different platforms.
  • APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available.
  • Fully multi-threaded using kernel threads.
  • Provides transactional and non-transactional storage engines.
  • Uses very fast B-tree disk tables (MyISAM) with index compression.
  • Very fast joins using an optimized one-sweep multi-join.
  • SQL functions are implemented using a highly optimized class library and should be as fast as possible.
  • Support for aliases on tables and columns as required by SQL-92.
  • Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
  • Clients may connect to the MySQL server using TCP/IP sockets on any platform.
  • The Connector/ODBC interface provides MySQL support for client programs that use ODBC (Open-DataBase-Connectivity) connections.
  • The Connector/JDBC interface provides MySQL support for Java client programs that use JDBC connections.

Table of Contents

 About This Book

 Introduction of SQL

MySQL 4.0 Introduction and Installation

MySQL 4.0 Introduction

 Installing MySQL 4.0.18

 Creating First Table in MySQL

 Installing MySQL 5.5.15

 Installing MySQL 5.0.2 (Alpha)

 Introduction of MySQL 5.0 Programs

 Perl Programs and MySQL Servers

 PHP Programs and MySQL Servers

 Java Programs and MySQL Servers

 Datatypes and Data Literals

 Operations and Expressions

 Character Strings and Bit Strings

 Commonly Used Functions

 Table Column Types for Different Types of Values

 Using DDL to Create Tables and Indexes

 Using DML to Insert, Update and Delete Records

 Using SELECT to Query Database

 Transaction Management and Isolation Levels


 Defining and Calling Stored Procedures

 Variables, Loops and Cursors Used in Stored Procedures


 Printable Copy - PDF Version

MySQL 4.0 Introduction - Updated in 2012, by Dr. Herong Yang