12-17-2004
data base
Dear sirs,
I am new to DataBase in C++,Also here iam using mysql,
How can do it nad get the result back from the database and do operation onit.
Thanks in advance,
arunkumar
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am having trouble through, I am reading the input from tab delimited file containing several records,
e.g.
line1 field1 field2 field3 so on..
line2 field1 field2 field3 so on..
..
..
on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies
2. Shell Programming and Scripting
hello everyone
I need to update data base in file
1-ID
2-Name
3-ID group
4-ID teacher
5-mark list
unique ID is (ID+ID group+ID teacher)
we can append 5 th columns (marks list)
main base file:
Code:
1:John:3:1:4 3 2
2:Mark:1:2:1 3
3:Susan:3:4:
input file: (1 Reply)
Discussion started by: mleplawy
1 Replies
3. Shell Programming and Scripting
Is this a permission issue I got this shl that runs okay in one data base but not in another DB in UNIX
i changed the real names for xxx for this post
!/bin/ksh
set -x
##SID="$1";
##SIDQ="@${SID}";
##ORACLE_SID="@${SID}";
# set database name
SID=$ORACLE_SID;
LOWER_SID=`echo... (1 Reply)
Discussion started by: rechever
1 Replies
4. Shell Programming and Scripting
HI
I have input file A.txt
X
Y
Z
File B.txt
1 X 10 AAA 11123
2 Y 22 PlD 4563
3 Z 55 PlD 54645
4 Z 66 PlD 15698
5 F 44 PlD 154798
6 C 55 PlD 12554
7 Z 88 PlD 23265
8 C 99 PlD 151654
9 C 11 PlD 21546546
I need New File C.txt (1 Reply)
Discussion started by: pareshkp
1 Replies
5. Shell Programming and Scripting
Hi All,
I have the file in following format. I need to change column 16 and column 17 for those lines which has atleast one numerical digit in column 2 , with the exception on SUPP1
Input file :
S00005615|1044|0|0.00|0|0.00| |112|-30|28.1|0|0| |20130331|220.2|2|3|... (2 Replies)
Discussion started by: nua7
2 Replies
6. Shell Programming and Scripting
Base of last two column i want to change may data
if Last two Column have A and C then Copy Column $4 to Column $3.
Input :-
DD142 0_1 DD142_A DD142_B A B
DD142 1_1 DD142_B DD142_C B C
DD142 2_1 DD142_A DD142_C A C
DD142 3_1 DD142_A A
DD142 3_2 DD142_A A
DD142 4_1 DD142_B B ... (4 Replies)
Discussion started by: pareshkp
4 Replies
7. Shell Programming and Scripting
File 1
ID Name Po1 Po2
DD134 DD134_4A_1 NN-1 L_0_1
DD134 DD134_4B_1 NN-2 L_1_1
DD134 DD134_4C_1 NN-3 L_2_1
DD142 DD142_4A_1 NN-1 L_0_1
DD142 DD142_4B_1 NN-2 L_1_1
DD142 DD142_4C_1 NN-3 L_2_1
DD142 DD142_3A_1 NN-41 L_3_1
DD142 DD142_3A_1 NN-42 L_3_2
File 2 ( Combination of... (1 Reply)
Discussion started by: pareshkp
1 Replies
8. Shell Programming and Scripting
HI
Want to grep data from column header and match with second file.
File A.txt
1 2 3 4 5 6
X1 A L D J Q R
X2 B M K P w T
X3 C S L P e Y
X4 R Z M A r U
FileB.txt
1
2
3
4
6
7 (3 Replies)
Discussion started by: pareshkp
3 Replies
9. Shell Programming and Scripting
HI Guys,
File A.txt
UID,HD1,HD2,HD3,HD4
1,2,33,44,55
2,10,14,15,16
File B.txt
UID
HD1
HD4
A.txt B.txt >>>Output.txt
UID,HD1,HD4
1,2,55
2,10,16 (11 Replies)
Discussion started by: pareshkp
11 Replies
LEARN ABOUT DEBIAN
notedb::mysql
NOTEDB::mysql(3pm) User Contributed Perl Documentation NOTEDB::mysql(3pm)
NAME
NOTEDB::mysql - module lib for accessing a notedb from perl
SYNOPSIS
# include the module
use NOTEDB;
# create a new NOTEDB object (the last 4 params are db table/field names)
$db = new NOTEDB("mysql","note","localhost","username","password","note","number","note","date");
# get a single note
($note, $date) = $db->get_single(1);
# search for a certain note
%matching_notes = $db->get_search("somewhat");
# format of returned hash:
#$matching_notes{$numberofnote}->{'note' => 'something', 'date' => '23.12.2000 10:33:02'}
# get all existing notes
%all_notes = $db->get_all();
# format of returnes hash like the one from get_search above
# get the next noteid available
$next_num = $db->get_nextnum();
# recount all noteids starting by 1 (useful after deleting one!)
$db->set_recountnums();
# modify a certain note
$db->set_edit(1, "any text", "23.12.2000 10:33:02");
# create a new note
$db->set_new(5, "any new text", "23.12.2000 10:33:02");
# delete a certain note
$db->set_del(5);
# turn on encryption. CryptMethod must be IDEA, DES or BLOWFISH
$db->use_crypt("passphrase", "CryptMethod");
# turn off encryption. This is the default.
$db->no_crypt();
DESCRIPTION
You can use this module for accessing a note database. There are currently two versions of this module, one version for a SQL database and
one for a binary file (note's own database-format). However, both versions provides identical interfaces, which means, you do not need to
change your code, if you want to switch to another database format.
Currently, NOTEDB module is only used by note itself. But feel free to use it within your own project! Perhaps someone want to implement a
webinterface to note...
USAGE
please see the section SYNOPSIS, it says it all.
AUTHOR
Thomas Linden <tom@daemon.de>.
perl v5.10.1 2011-02-12 NOTEDB::mysql(3pm)