interface pascal with mysql

[sanath]

How to interface pascal with mysql?

With Regards,
Sanath - World Airport Times

[nirmala]

Hi..
You can use Free Pascal to access a MySQL database server from Linux.
Installation
The mysql interface is distributed with the Free Pascal packages, and come with the compiler distribution: Normally no action should be taken to work with MySQL.
In case you want to modify and compile the units yourself, the mysql sources are in the packages directory:
packages/base/mysql
This directory contains the units, a test program and a makefile. cd to the directory and type
make
This should compile the units. If compilation was succesful, you can install with
make install
You can then test the program by running
make test
This will:

* Run a script to create a table in a database, and fill it with some data. (the mysql program should be in your PATH for this). By default, the used database is testdb.
* Run the testprogram testdb
* Run a shell script again to remove the created table.

You will see a lot of messages on your screen