Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::mysql(3pm) [debian man page]

DBIx::Class::Storage::DBI::mysql(3pm)			User Contributed Perl Documentation		     DBIx::Class::Storage::DBI::mysql(3pm)

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 = MyDb::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
You may distribute this code under the same terms as Perl itself. perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::mysql(3pm)

Check Out this Related Man Page

DBIx::Class::Storage::DBI::AutoCast(3pm)		User Contributed Perl Documentation		  DBIx::Class::Storage::DBI::AutoCast(3pm)

DBIx::Class::Storage::DBI::AutoCast - Storage component for RDBMS requiring explicit placeholder typing SYNOPSIS
$schema->storage->auto_cast(1); DESCRIPTION
In some combinations of RDBMS and DBD drivers (e.g. FreeTDS and Sybase) statements with values bound to columns or conditions that are not strings will throw implicit type conversion errors. As long as a column data_type is defined and resolves to a base RDBMS native type via "_native_data_type" as defined in your Storage driver, the placeholder for this column will be converted to: CAST(? as $mapped_type) This option can also be enabled in connect_info as: on_connect_call => ['set_auto_cast'] connect_call_set_auto_cast Executes: $schema->storage->auto_cast(1); on connection. Used as: on_connect_call => ['set_auto_cast'] in connect_info. AUTHOR
You may distribute this code under the same terms as Perl itself. perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::AutoCast(3pm)
Man Page

11 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connecting MySql throug Perl Script ?

Dear Friends, I am tryin to connect to the myql through perl scrip. I have already installed mysql and DBI modules to my Perl. There versions are as follows, DBD-mysql MySQL driver for the Perl5 Database DBI Database independent interface for It gives... (4 Replies)
Discussion started by: maheshsri
4 Replies

2. Linux

MySQL server connetction problem

Hello,thanks for your help. I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this? Thanks again! (4 Replies)
Discussion started by: lancepanda
4 Replies

3. UNIX for Dummies Questions & Answers

Backing Up and Emailing Home Directory and SQL Databases

Hello, I run a web hosting company, and I'm wondering how I can use cPanel's Cron Jobs so that a copy of my entire home directory and a copy all of my MySQL databases can be compressed and emailed to me. I know nothing about Linux, Unix, or whatever that thing with the penguin is called. :) ... (7 Replies)
Discussion started by: millipedeman
7 Replies

4. Shell Programming and Scripting

perl DBI inserting date\time

hi there, my mysql database has a date/time field using the standard mysql date|time format of 2009-08-31 00:16:44 when inserting into this field using perl DBI, is there is an easy way to insert the current date/time in without having to preformat the date/time string in perl before... (3 Replies)
Discussion started by: hcclnoodles
3 Replies

5. Solaris

Sun Open Storage Questions

Hey All, I had some minor questions regarding Sun's open storage I understand it uses standard industry hardware (is the warranty void if we were to mix and match drives?) I know it uses OpenSolaris for the storage features (but can it use any os?) Does it have to be OpenSource? I... (7 Replies)
Discussion started by: Keepcase
7 Replies

6. Programming

SQL datetime calculation

Suppose I have a mysql table consisting of measurements taken during irregular intervals as follows: CREATE TABLE data (datetime DATETIME, value INTEGER); mysql> SELECT datetime, value FROM data; +---------------------+---------+ | datetime | value |... (2 Replies)
Discussion started by: figaro
2 Replies

7. Ubuntu

Database Connection

Hi, How to creating connection to mysql.I try to connect but the following error coming .How to solve it. Could not connect to New MySQL. Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver) com.mysql.jdbc.Driver Error creating JDBC Connection... (2 Replies)
Discussion started by: snallusami
2 Replies

8. Red Hat

Problem in installing mysql

Hi i am trying to install mysql rpm package on my linux machine but getting below error : warning: MySQL-embedded-5.5.28-1.rhel5.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: MySQL-devel is needed by MySQL-embedded-5.5.28-1.rhel5.i386 ... (9 Replies)
Discussion started by: mukulverma2408
9 Replies

9. Programming

C connectivity with mysql

I want to connect c with mysql database. want to do all the database transaction. i want some tutorial.... (7 Replies)
Discussion started by: amisubha
7 Replies

10. AIX

AIX - Fibre Adapter and IBM Storage

Hello, Just a quick question Usually from a PSERIES if you want to connect to IBM SAN Storage you connect the IBM SAN Storage through a SAN Switch something like this --- however my question Can you connect from Pseries directly to San Storage without SAN Switch what would be... (8 Replies)
Discussion started by: filosophizer
8 Replies

11. Programming

MySQL GUI recommendation

I just wanted to share what a great MySQL (and other SQL) GUI DevArt provides. 3 years ago our company adopted a new ERP system that's entirely LAMP based. UGGG! Seriously? SQL Server *upgrade* to MySQL!??? This ERP is entirely vendor supported, but I have a replica database for data... (3 Replies)
Discussion started by: vich
3 Replies