Free tutorials for Java, Eclipse and Web programming



MySQL - Tutorial

Lars Vogel

Version 0.7

07.10.2009

Revision History
Revision 0.1 - 0.203.02.2008Lars Vogel
created
Revision 0.309.01.2009Lars Vogel
Added installation, Reworked
Revision 0.525.05.2008Lars Vogel
Moved Java part to own article at http://www.vogella.de/articles/MySQLJava/article.html
Revision 0.613.09.2009Lars Vogel
General rework
Revision 0.707.10.2009Lars Vogel
Moved SQL commands to own tutorial

MySQL

This article explains how to install MySQL and how to create and query a database.

This article uses Java 1.6 and MySQL 5.1.


Table of Contents

1. Overview
2. Installation
2.1. Windows
2.2. Linux (Ubuntu)
3. Connecting to MySQL
4. Create example database
5. Further SQL commands
6. Thank you
7. Questions and Discussion
8. Links and Literature

1. Overview

MySQL is a famous open source database which can be used free of charge. MySQL is a relational database. Web applications frequently are using MySQL for storing persistence data.

This article covers the installation of MySQL and the usage of the database.

To use MySQL with Java see MySQL and Java Tutorial .