Home Portal Search

Overview

People

Teaching

Projects

Resources

Intranet

TECFA's MySQL page

MySQL is a SQL (Structured Query Language) database server. SQL is the most popular database language in the world. MySQL is a client server implementation that consists of a server daemon mysqld and many different client programs/libraries.

The main goals of MySQL are speed and robustness. MySQL is TECFA's favorite database. It's free, it never crashes, it's fast and it's not too hard to build WWW applications together with PHP.

Contents

MySQL @ TECFA
§ 1.1 Teaching @ TECFA § 1.2 Projects @ TECFA

Documentation
§ 2.1 Manuals § 2.2 MySQL Tutorials § 2.3 Printed Books § 2.4 SQL/ Data base tutorials § 2.5 JDBC related Tutorials / Articles/ API § 2.6 Mailing Lists

Software
§ 3.1 Programmer's Libraries (jdbc, ...) § 3.2 Clients (MySQL administration)

Examples
§ 4.1 PHP/MySQL § 4.2 JDBC/MySQL

Links

Other DBs at TECFA
§ 6.1 Berkeley DB § 6.2 PostgreSQL

MySQL @ TECFA Documentation Software Examples Links Other DBs at TECFA

Contents
MySQL @ TECFA § 1.1 Teaching @ TECFA § 1.2 Projects @ TECFA Documentation § 2.1 Manuals § 2.2 MySQL Tutorials § 2.3 Printed Books § 2.4 SQL/ Data base tutorials § 2.5 JDBC related Tutorials / Articles/ API § 2.6 Mailing Lists Software § 3.1 Programmer's Libraries (jdbc, ...) § 3.2 Clients (MySQL administration) Examples § 4.1 PHP/MySQL § 4.2 JDBC/MySQL Links Other DBs at TECFA § 6.1 Berkeley DB § 6.2 PostgreSQL

1. MySQL @ TECFA

At TECFA we run MySQL on both Solaris server machines. We use version mysql-3.23.48-sun-solaris2.8-sparc (or better).

1.1 Teaching @ TECFA

TECFA Slides: regardez ici sous MySql Trail

1.2 Projects @ TECFA

(under construction, Patrick mets ce que tu veux)

MySQL Memo (Under construction, french) - (All in one PDF version: 207K)
MySQL Admin - very short guide
PHP/MySQL Demo

2. Documentation

See the Documentation page at the MySQL site for more and check for other stuff.
Also: JDBC MySQL Driver documentation is in the Software section.

2.1 Manuals

Locally installed Manuals (version 3.23.?):

Nexen packaged English Version (129 files)
le HUGE original. This Html file has a separate TOC
Manuel français (de nexen, 129 fichiers.

Originals, get them yourselves from here:

2.2 MySQL Tutorials

PHP/MySQL Tutorial (by G. Merall at Webmonkey/HotWired)
Introduction aux pages web actives avec PHP et MySQL par Olivier Martineau

2.3 Printed Books

DuBois Paul, Widenius Monty (1999) MySQL, New Riders Publishing; ISBN: 0735709211, 850 pages. Dont' have it, but it gets good reviews
Randy Jay Yarger, George Reese, Tim King (1999), MySQL and mSQL, O'Reilly & Associates; ISBN: 1565924347
Craig Hilton, Jeff Willis, Bjorn Borud (Dec 1999), Building Database Applications on the Web Using PHP3: Addison-Wesley Pub Co; ISBN: 0201657716. Good reviews, focus on Postgres
Judith S. Bowman, Sandra L. Emerson (Contributor), Marcy Darnovsky (Contributor) (1996), The Practical Sql Handbook : Using Structured Query Language, Addison-Wesley Pub Co; ISBN: 0201447878. [ Focus on Beginners ]

2.4 SQL/ Data base tutorials

Les cours bases de données/ SQL de Richard Grin (Des copies verouillées sous format *ps.gz sont disponibles localement)
The Nuts and Bolts of Relational Databases A Primer for Web Developers by Duane K.Fields
SQLCourse.com. SQL Interpreter & Tutorial with live practice database.
Web Searchable Databases Several good articles including Selena Sol's Introduction to Databases for the Web
Relational Databases and SQL (Good on-line tutorial) [ old local copy (protected) ]
http://w3.one.net/~jhoffman/sqltut.htm [DEAD LINK I'd like to find again] Introduction to Structured Query Language. Good online SQL tutorial.
Illustra for Earth Scientists Contains an SQL Tutorial (Illustra does more than MysQL, but the basics are the same!)
Database courseware A hyperlinked collection of (abstract) database concepts.

2.5 JDBC related Tutorials / Articles/ API

API Documentation

LOCAL 1.1.7 java.sql API doc
MM/Mysql Driver doc (local copy, password protected)
SUN's JDBC API Page (includes docs, FAQ, downloads and pointers to drivers

JDBC Tutorials

Adding Database Support With JDBC A Primer for Java Programmers, by Duane K.Fields
JDBC 2.0 Fundamentals jGuru (ex-MageLange) Tutorial
JDBC Short Course (Magelang Institute) . Good (only lacks information on how to deal with non standard drivers)
Sun's JDBC Data Acess API page
INDEX: JDBC and Java database programming books: A comparative review Good !
JDBC API Interface in a Nutshell
JDBC Database Access (password protected, part of SUN's http://java.sun.com/docs/books/tutorial/). Good place to start !
To move on: SUN's JDBC(TM) - Connecting Java and Databases . Check Getting Started
Writing Database Applications in Java, Using Java With Jdbc And Sql by S.T. Abell, Netscape (JDBC/ODBC) See also: Writing Database Applications In Java (General Overview)
Deploying Java and JDBC. Good introduction about the FOUR types of Java JDBC Solutions.
See also: JDBC FAQ
Scale an application from 2 to 3 tiers with JDBC (JavaWorld apr 1999 or 1997 ?? article)

2.6 Mailing Lists

3. Software

See also the list of contributed programs at the MySQL Site. Here we list just software that we use or plan to use:

3.1 Programmer's Libraries (jdbc, ...)

See ALSO: SUN's java.sql API doc (local password protected). You get this page from your own JDK API doc.

See Tecfa's PHP Page which includes PHP/MySQL related stuff. At Tecfa the language of choice for Web-based MySQL applications is PHP. Just started learning JDBC, 1/99 :)
DataBase Interfaces Kreator (2002, not tested yet)

JDBC Drivers

Currently (1/99) only mm and twz1 seem to be popular. Both are free. See also the JDBC Section for general JDBC Tutorials. [Tecfa Users: Classes are in /local/java/classes/xxx..]

MM MySQL JDBC Drivers Mark Matthews GPL licensed driver. Fasted it seems. INSTALLED at TECFA: local documentation (password protected)
twz1jdbcForMysql (aka tjFM) JDBC Driver Terrence W. Zeller's driver (free for private and educational use) INSTALLED at TECFA: local documentation (password protected). Easier to start with (has several examples).
GWE mysql JDBC Driver Includes an applet version. (outdated ?, last version: 0.9.2 3/97 as of 1/99)
SEE: SUN's Coffee Break Examples ("implemented" at TECFA)

Utilities / adaptable clients

MySQL-Formmaker is a tool for creating easy adminstration forms and ouput of data. (Needs MySQL & PhP)
DbConnectionBroker, a pure Java package for handling multiple concurrent database connections.
TableGen. This package automatically generates classes to represent tables within a database. It is released under GPL. (works with the twz/mm MySQL drivers.

3.2 Clients (MySQL administration)

For GUIs, see the downloads section of www.mysql.com. You can find e.g. MySQLGUI. There are others but we can't keep track of them
phpMyAdmin, Web-based client

4. Examples

4.1 PHP/MySQL

PHP/MySQL Demo (made in TECFA)
Kleinanzeigenmarkt mit PHP3 and MySQL

4.2 JDBC/MySQL

SUN's Coffee Break Examples ("implemented" at TECFA)
MapLinks de JCB from Tecfa
Jdbc Test at Kevin's place (made with the GWE Driver)
Jeff Schmitt's JDBC Page has a short tutorial (including source for Mysql and Oracle)

5. Links

Official MySQL Home Page
Useful SQL or relational db INDEX (at www.inquiry.com).
PostgreSQL (an alternative)
Sybase has a free version (one CPU (define), 5 GB (define) of storage and 2 GB of RAM. This is probably the best free Linux DB (if you need a real database or if you want an easy convert from Microsoft SQL) (sept 2004).
an altertive, small 100K Java Code, very good for deployment with servlets

To to be moved out /explored etc.

List of ODBC SQLState codes
OODB Pointers (new)
LDL++ System (interesting project. The Logical Data Language combines DBs and KBs, to explore some day)
Why aren't you using an oodms. Also at: kuro5hin

6. Other DBs at TECFA

6.1 Berkeley DB

Local documentation (Maybe OLD

6.2 PostgreSQL

www.postgresql.org (redirects to fastest nearby mirror server, reload if you are unhappy)
Postgres - a free SQL database for Solaris (introductory article)

D.K.S.