MySQL Tutorials - Herong's Tutorial Examples
∟Introduction of MySQL 5.0 Programs
This chapter provides notes and tutorial examples on MySQL 5.0 programs. Topics include a list of MySQL 5.0 main programs; introduction of mysqld, mysqladmin, mysql, mysqldump, and mysqlimport.
List of MySQL Programs mysqld - The MySQL Server Program mysqladmin - The Client Tool for Administrators mysql - The Client Tool for End Users Using mysql to Run SQL Statements mysqldump - Dumping Data to Files mysqlimport - Loading Data from Files
List of MySQL Programs
mysqld - The MySQL Server Program
mysqladmin - The Client Tool for Administrators
mysql - The Client Tool for End Users
Using mysql to Run SQL Statements
mysqldump - Dumping Data to Files
mysqlimport - Loading Data from Files
Conclusions:
Table of Contents
About This Book
Introduction of SQL
MySQL 4.0 Introduction and Installation
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
Locks-Used-in-MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
References
Printable Copy - PDF Version