Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

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

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

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.16.2 2012-08-16 DBIx::Class::Storage::DBI::mysql(3)

Check Out this Related Man Page

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

DBIx::Class::Storage::DBI::Pg - Automatic primary key class for PostgreSQL SYNOPSIS
# In your result (table) classes use base 'DBIx::Class::Core'; __PACKAGE__->set_primary_key('id'); DESCRIPTION
This class implements autoincrements for PostgreSQL. POSTGRESQL SCHEMA SUPPORT
This driver supports multiple PostgreSQL schemas, with one caveat: for performance reasons, data about the search path, sequence names, and so forth is queried as needed and CACHED for subsequent uses. For this reason, once your schema is instantiated, you should not change the PostgreSQL schema search path for that schema's database connection. If you do, Bad Things may happen. You should do any necessary manipulation of the search path BEFORE instantiating your schema object, or as part of the on_connect_do option to connect(), for example: my $schema = My::Schema->connect ( $dsn,$user,$pass, { on_connect_do => [ 'SET search_path TO myschema, foo, public' ], }, ); AUTHORS
You may distribute this code under the same terms as Perl itself. perl v5.14.2 2011-11-29 DBIx::Class::Storage::DBI::Pg(3pm)
Man Page

12 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. UNIX for Dummies Questions & Answers

Using MySQL

Hello. I am using ubuntu linux and I have instaled on it mySQL. The problem is that it doesn't add link to it in the application menu. Hod I use from the CLI, and second how to add it to the application menu. (6 Replies)
Discussion started by: programAngel
6 Replies

7. Programming

MySQL join four tables!

Hello; I want merge four MySQL tables to get the intersection that have a common field for all of them. Join two tables is fine to me, but my this case is different from common situations and there are not very many discussions about it. Can anybody give me some idea? Thanks a lot! Here is part... (8 Replies)
Discussion started by: yifangt
8 Replies

8. Programming

Getting Rows from a MySQL Table with max values?

I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work. Basically I wrote code like this: select * from `Test_DC_Trailer` HAVING max(DR_RefKey); Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
Discussion started by: Astrocloud
7 Replies

9. 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

10. 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

11. 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

12. Web Development

Node.js and mysql - ER_ACCESS_DENIED_ERROR

This problem has been killing me all day, and I cannot solve it. Basically, I am using node.js with the mysql module and it will not connect to the database. Here is the JS code snippet in node.js: app.get("/test", function(req, res) { var mysql = require("mysql"); var con =... (4 Replies)
Discussion started by: Neo
4 Replies