If anyone is interesting in using awk with MySQL databases, then I have some good news:

I've developed a (shared) library, namely libspawk.so, using MySQL C API and GNU awk's extension feature. If you are using MySQL and you like awk, then you'll find very useful to use SPAWK module.

Please visit my web site http://sites.google.com/site/spawkinfo to download the library and a test awk script to start with. You'll also find a complete reference manual, a tutorial and various examples in this URL. I'll apreciate your help in trying to run the test script in your environment.

I've tested the SPAWK library with GNU awk 3.1.6 and MySQL 5.0.45. I want to know if other versions of MySQL can work ok with the SPAWK module. Don't afraid of testing, the test (test00.awk) only prints all the columns of all the tables of all databases.

I've tested yesterday (May 9, 2009) the SPAWK module for MySQL 6.0 and passed! The test was unsuccesfull for the downloaded libspawk.so, so I downloaded the object spawk.o and makelib.sh shell script and run

    sh makelib.sh