NAME
    IO::Adapter::MySQL - interface to talk with a MySQL server.

SYNOPSIS
       use IO::Adapter;

       my $map        = 'mysql:toymodel';
       my $map_params = {
           $map       => {
            sql_servers   => 'localhost',
            user          => 'fukachan',
            user_password => 'uja',
            database      => 'fml',
            table         => 'ml',
            params        => {
                ml_name   => 'elena',
                file      => 'members',
            },
           },
       };

       my $obj = new IO::Adapter ($map, $map_params);
       $obj->open();
       $obj->add( 'rudo@nuinui.net' );
       $obj->close();

DESCRIPTION
    This module is a top level driver to talk with a MySQL server in SQL
    (Structured Query Language). This module inherits "IO::Adapter::DBI"
    class.

    The model dependent SQL statement is expected to be holded in
    "IO::Adapter::SQL::" modules.

    You can specify your own module name at $args->{ driver } in new($args).
    It is expected to provide "add()" and "delete()" methods.

METHODS
  configure($me, $args)
    IO::Adapter::MySQL specific configuration loader. It also calles
    IO::Adapter::SQL::$model module for model specific customizatoins and
    functions.

  setpos($pos)
    set position in returned cache.

    MySQL does not support rollack, so we close and open this transcation.
    After re-opening, we moved to the specified $pos.

  getpos()
    get position in returned cache.

  eof()
    check if EOF or not?

SEE ALSO
    DBI, DBD::MySQL, IO::Adapter::DBI

CODING STYLE
    See "http://www.fml.org/software/FNF/" on fml coding style guide.

AUTHOR
    Ken'ichi Fukamachi

COPYRIGHT
    Copyright (C) 2000,2001,2002,2003,2004,2005 Ken'ichi Fukamachi

    All rights reserved. This program is free software; you can redistribute
    it and/or modify it under the same terms as Perl itself.

HISTORY
    IO::Adapter::File first appeared in fml8 mailing list driver package.
    See "http://www.fml.org/" for more details.