02-20-2009
latter i came to know that no scrpting is there in mysql.So populate the db with 100K rows i had to write a procedure and its working
=========================
DELIMITER $$
DROP PROCEDURE IF EXISTS `AMITDB`.`test_proc3` $$
CREATE PROCEDURE `test_proc3`(IN c INT)
begin
while c < 1000001 do
insert into AMITDB (ID, COMPONENT, COMPONENT_TYPE) values(c,c,'AMIT_ALCATEL');
set c=c+1;
end while;
END $$
DELIMITER ;
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi frind,
i="1"
while
do
echo "i is $i"
data_file=$HYP_ROOT/import/efcextr$i.txt
echo "$data_file"
i=`expr $i + 1`
done
This is woring finly in ksh but not in ksh.
in ksh it showing error
i=1: Command not found
i: Undefined variable
Kindly help me ...why it is showing the error... (1 Reply)
Discussion started by: deep_kol
1 Replies
2. Shell Programming and Scripting
I recently installed Cygwin on my windows vista to practice on Linux\unix commands.
I am unable to do a simple task of declaring variables on the command prompt
I am trying:
$ vech=Bus
$ echo $vech
bash: vech : command not found
What am I missing? Do i need to add something to .bashrc?
... (1 Reply)
Discussion started by: erora
1 Replies
3. UNIX for Dummies Questions & Answers
hi to all,
i am trying to declare a variable as an integer in unix shell script. i search the web for a way to do it but it doesnt work.
i tried "define -i" and "declare" but that doesnt work.
if somebody knows another way to declare a variable as integer please help me.
thank you (2 Replies)
Discussion started by: omonoiatis9
2 Replies
4. Shell Programming and Scripting
Hi
I've few shell scripts which are responsible for triggering the continuous builds for a specific module. Each shell script is for a Module. Shell script has some module specific settings in the beginning and then it triggers the builds (which are nothing but some combination of Java programs... (2 Replies)
Discussion started by: kgsrinivas
2 Replies
5. Shell Programming and Scripting
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies
6. Shell Programming and Scripting
what I'm trying to do is ... need to drop tables w/ names like
ABC_NY_2001
ABC_ORD_2001
ABC_TX_2001
ABC_CL_2001
For this, I want to write a query "DROP TABLE ABC_var_2001".
now "var" should be either NY, ORD, TX or CL.
I'm new to programming so don't know how to create a variable w/ OR... (3 Replies)
Discussion started by: ramsowji
3 Replies
7. Shell Programming and Scripting
I am trying to declare a variable like this
#!/bin/csh -f
set c_arg = $a $b $c
However, since i need it to declare before declaring $a ,$b or $c.
As of now i am getting an error which says $a not defined.
Is it possible to define a variable c_arg w/o interpreting the values $a $b $c (2 Replies)
Discussion started by: animesharma
2 Replies
8. Shell Programming and Scripting
how can i declare variable in perl.
for BLOCK in /sys/block/emcpow* (3 Replies)
Discussion started by: learnbash
3 Replies
9. Shell Programming and Scripting
Hello,
i have the following code :
somevariable=`mysql -u root --password="" databasename -e "select count(column_name) from table_name where id=1 and id_age=2 ; " --skip-column-names -s -N`
if ]
then ....
It gives the message
")syntax error: invalid arithmetic operator (error... (2 Replies)
Discussion started by: juve11
2 Replies
10. Shell Programming and Scripting
If I am running a bash command, and some awk getting the ethernet adapter on the local machine. It works fine. But if I will run it from the remote, it is EMPTY on echo and throwing error in grep.
Thank you
This work perfectly fine
$ f=`/sbin/ip a|grep 127.127 | awk '{print $NF }' ` ; ip... (2 Replies)
Discussion started by: kenshinhimura
2 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)