09-26-2009
The problem seems to have to do with the web form used. The code is correct and should be used within the mysql prompt/shell itself.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm trying to define a variable named sin
I already have a variable named cos, which has the value "hello"
I want sin to have the value of "hellothere",
so sin would be something like
sin = $cos & "there"
but I'm not sure that I know the syntax.
Can anyone help?
:confused: (4 Replies)
Discussion started by: sailorliones
4 Replies
2. AIX
I've got a modified samba script (named it winprint) that I can use to print out to a to a shared Win Network printer from an AIX machine. This is a modification of the samba provided smbprint script changed to work under AIX as the backend for a queue. It does not read a config file
I can print... (0 Replies)
Discussion started by: matheeq
0 Replies
3. Shell Programming and Scripting
Hey all, I was wondering if someone would take a look at this script I'm working on. I don't know if i have the syntax correct for my variables and if the for loop is written correctly.
any assistance would be greatly appreciated.
#!/usr/bin/bash
###########################################... (12 Replies)
Discussion started by: em23
12 Replies
4. Programming
Question regarding extend issue
What is the reason behind defining the inputStream object in this way...
InputStream inputStream = new FileInputStream("c:\\input.txt");
I know that FileInputStream extends InputStream, is there anything else ?
I mean we could have define it like ... (0 Replies)
Discussion started by: yahyaaa
0 Replies
5. UNIX for Dummies Questions & Answers
I have defined this alias as quick way to find out which mount point to use for a USB drive after inserting it:
# alias da='dmesg | grep da | grep MB'
However, when invoking it, it states the following:
# da
da: Command not found.
Can someone explain what is the issue here and how it can be... (3 Replies)
Discussion started by: figaro
3 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I have a trivial question but I dont know how to solve it.
So basically I'm working on a USB key and I have a directory with some scripts which I use to work on files present in other directories within the USB or sometimes on the main harddisk too. The problem is every time I have to... (3 Replies)
Discussion started by: pawannoel
3 Replies
7. Programming
I have the following code and getting the compilation errors
baseLib/DynBaseObj.h:80: error: expected constructor, destructor, or type conversion before ‘(' token
baseLib/DynBaseObj.h:89: error: expected constructor, destructor, or type conversion before ‘(' token
baseLib/DynBaseObj.h:101:... (0 Replies)
Discussion started by: kristinu
0 Replies
8. Shell Programming and Scripting
Hi Friends,
I am newbie to shell programming and I am stuck trying to accomplish following task.We use Bamboo CI which executes script1 passing parameters. This Main script executes script2 as backend process as part of one of it statements. Task of script2 is to essentially check whether a... (0 Replies)
Discussion started by: aditya206
0 Replies
9. UNIX for Dummies Questions & Answers
Hi
I'd say I'm having this weird problem where my script isn't taking the value off a variable or printing it. My code is like this:
set count_C= `grep -c C mols`
set count_H= `grep -c H mols`
set count_O= `grep -c O mols`
sed -i '7,7 s/$/ $count_C $count_O $count_H/g' input It... (8 Replies)
Discussion started by: saleheen
8 Replies
LEARN ABOUT CENTOS
cgi::session::driver::mysql
CGI::Session::Driver::mysql(3) User Contributed Perl Documentation CGI::Session::Driver::mysql(3)
NAME
CGI::Session::Driver::mysql - CGI::Session driver for MySQL database
SYNOPSIS
$s = new CGI::Session( 'driver:mysql', $sid);
$s = new CGI::Session( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test',
User => 'sherzodr',
Password => 'hello' });
$s = new CGI::Session( 'driver:mysql', $sid, { Handle => $dbh } );
DESCRIPTION
mysql stores session records in a MySQL table. For details see CGI::Session::Driver::DBI, its parent class.
It's especially important for the MySQL driver that the session ID column be defined as a primary key, or at least "unique", like this:
CREATE TABLE sessions (
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT NOT NULL
);
To use different column names, change the 'create table' statement, and then simply do this:
$s = new CGI::Session('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
DataSource=>'dbi:mysql:project',
});
or
$s = new CGI::Session('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DRIVER ARGUMENTS
mysql driver supports all the arguments documented in CGI::Session::Driver::DBI. In addition, DataSource argument can optionally leave
leading "dbi:mysql:" string out:
$s = new CGI::Session( 'driver:mysql', $sid, {DataSource=>'shopping_cart'});
# is the same as:
$s = new CGI::Session( 'driver:mysql', $sid, {DataSource=>'dbi:mysql:shopping_cart'});
BACKWARDS COMPATIBILITY
As of V 4.30, the global variable $CGI::Session::MySQL::TABLE_NAME cannot be used to set the session table's name.
This is due to changes in CGI::Session::Driver's new() method, which now allows the table's name to be changed (as well as allowing both
the 'id' column name and the 'a_session' column name to be changed).
See the documentation for CGI::Session::Driver::DBI for details.
In particular, the new syntax for "new()" applies to all database drivers, whereas the old - and bad - global variable method only applied
to MySQL.
Alternately, call $session -> table_name('new_name') just after creating the session object if you wish to change the session table's name.
LICENSING
For support and licensing see CGI::Session.
perl v5.16.3 2008-07-16 CGI::Session::Driver::mysql(3)