Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

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

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)

Check Out this Related Man Page

DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::CuUser(Contributed Perl DocumDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)

NAME
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor - Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO DESCRIPTION
This class is for removing trailing "NULL"s from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO. You probably don't want to be here, see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server driver for ADO and DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class. Unfortunately when using DBD::ADO, binary data comes back padded with trailing "NULL"s and GUIDs come back wrapped in braces, the purpose of this class is to remove the "NULL"s and braces. DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server sets cursor_class to this class by default. It is overridable via your connect_info. You can use DBIx::Class::Cursor::Cached safely with this class and not lose the binary data normalizing functionality, ::Cursor::Cached uses the underlying class data for the inner cursor class. AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class. LICENSE
You may distribute this code under the same terms as Perl itself. perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)
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. Shell Programming and Scripting

Problem with looping construct

Hi all I have tried to search for this, but keep getting a MySQL db connect error, so am posing the question here, and taking a risk of incurring the wrath of the mods with my first post... I have the following test script: #!/bin/bash HTTPD=`/bin/ps -axcu | /usr/bin/grep httpd... (6 Replies)
Discussion started by: mikie
6 Replies

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

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