MySQL 5.1 Use Case Competition


 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS MySQL 5.1 Use Case Competition
# 1  
Old 09-09-2008
MySQL 5.1 Use Case Competition

MySQL Community Team launches a competition for the users of new features of MySQL 5.1.Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 31 August 2008 and win!

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question
DBIx::Class::Storage::DBI::mysql(3)			User Contributed Perl Documentation		       DBIx::Class::Storage::DBI::mysql(3)

NAME
DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics SYNOPSIS
Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class. my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } ); DESCRIPTION
This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the relationship attributes It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far as the SQL standard is concerned. STORAGE OPTIONS
set_strict_mode Enables session-wide strict options upon connecting. Equivalent to: ->connect ( ... , { on_connect_do => [ q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|, q|SET SQL_AUTO_IS_NULL = 0|, ] }); AUTHORS
See "CONTRIBUTORS" in DBIx::Class LICENSE
You may distribute this code under the same terms as Perl itself. perl v5.18.2 2014-01-22 DBIx::Class::Storage::DBI::mysql(3)