NAME

DBIx::MySQLite - MySQL compatibility functions for DBD::SQLite.

SYNOPSIS

  use DBI;
  use DBIx::MySQLite 'add_all_functions';
  
  my $db = DBI -> connect ("dbi:SQLite:dbname=sql.ite","","", {RaiseError => 1});  
  
  DBIx::MySQLite::add_string_functions   ($db);
  DBIx::MySQLite::add_datetime_functions ($db);
  
  # or simply
  
  add_all_functions ($db);
  
  $db -> do ('UPDATE syslog SET dt = REPLACE(NOW(), '200', '175'...
  

ABSTRACT

  MySQL compatibility functions for DBD::SQLite.

DESCRIPTION

DBD::SQLite is a set of callback function definitions making it look more or less like MySQL. As of version 0.1, just a very basic set is available, patches are very welcome.

NOW()

Current timestamp, in format 'YYYY-MM-DD hh:mm:ss'.

DATE_FORMAT()

Only %Y, %m, %d, %H, %i and %S patterns are guaranteed, other may work (see POSIX::strftime).

REPLACE()

SEE ALSO

DBD::SQLite.

AUTHOR

D. E. Ovsyanko, <do@zanas.ru>

COPYRIGHT AND LICENSE

Copyright 2004 by D. E. Ovsyanko

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